LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding y-Values in budget curve app w/ excel James Gross IV Excel Discussion (Misc queries) 2 September 12th 05 02:21 AM
Finding y-values in budget curve app with Excel & VBA James Gross IV Charts and Charting in Excel 3 August 16th 05 04:41 PM
YTD Budget Sum if Actual Month has activities AGnes Excel Worksheet Functions 1 March 24th 05 09:25 PM
Automatically change tab reference TWC Excel Discussion (Misc queries) 2 February 2nd 05 10:17 PM
Find and Replace miket_jam Excel Discussion (Misc queries) 3 January 27th 05 02:15 AM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"