View Single Post
  #1   Report Post  
Tracey
 
Posts: n/a
Default Comparing actual spends against a budget

Hello

I don't know much about charting, but have a user who wants to do something
like this:

They have a chart which shows the actual expenditure on a number of items,
this is normal column chart. Having already created this chart, they now
want to include another set of values which show the budget for these items
and represent this in the chart.

What they are hoping to have is the original column chart with the budget
shown as columns "in the background" so that readers can compare what they
have spent with what they were allowed to spend.

Please can you advise as to the best way to achieve this? I looked at combo
charts but as I say, I am new to this. If it helps, the list of items
reaches around 10. We are using Excel 2003.

cheers
Tracey