showing variance between amounts in bar graph? please help

Hi there,

I am finding it hard to show data as I would like?

Please see attached for sample data.

What I would like is a column graph showing 2 bars for the months data (which I can do).

However, what I am finding hard is to show the difference (column F) amount above the 2 bars in amount with amount (percentage would be better).

I hope you can help?

Regards

N

Hi Andy,

Thanks for the reply and providing a example with the percentages.
Couple of questions though?

How would I show the percentage as a increase or decrease (-) if it goes up/down against previous month?

So for example Cost Centre 2 would show -23%, cost centre 4 would show 125%

Also, please can you explain the reason for adding columns I and J?

Your help is much appreciated all.

Regards

N