Bar chart without dimensions

[#1]

Hi.

I would like to create a bar chart based on the table below but only with the one bar för each period and the total.

What is the easiest way to do that? I've attached a excel to show how I mean.

Dimension	LM	YTD	FC 2
Staffing costs direct	-34 000	-700 000	-1 000 000
Administrative costs	-8 000	-30 000	-200 000
Invoiced costs	-5 000	-20 000	-30 000
Operating costs	-7 800	-40 000	-70 000
Staffing costs indirect	-1 500	-10 000	-40 000
Performance	22 000	2 000	40 000
Other revenues	33 000	5 000	10 000
Invoiced costs	13 000	1 000 000	2 000 000
	11 700	207 000	710 000

Thanks in advance.

[vikasmahajan]

You can display this information in Text box instead of bar chart

for e.g                        Sales          Tys         Lys      % Grw

Hope this help you. Pls refer jpg for more ...

Vikas

[Gysbert_Wassenaar · Accepted solution]

Add a bar chart with only three expressions, one for each period. See attached example