LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Randy Lefferts
 
Posts: n/a
Default Custom charting - Stacked charting with a line

This may be difficult to explain but am going to try :)

I need to track "Liaison Costs" and "Sorting Costs" by
month. I also need to compare "Liaison Costs" to a
budget and generate the difference on the chart for the
given month, at the same time displaying a stacked bar
that shows the "Liaison Costs" and "Sorting Costs".

For example:

Jan Feb Mar
Liaison Costs 15,000 16,000 9,000
Sorting Costs 6,000 15,000 11,000

Budget 15,000 15,000 15,000

So now I need to plot the charges for sorting and
liaisons as a stacked bar. I also need to compare the
liaison costs vs the budget and display the difference.

I can display it so that the liaison costs are on the
bottom of the stack bar and then draw a line across the
months to represent the budget of 15000. The part I am
stumped on is whether it would be possible to now display
the difference along the "line" that represents the
budget (or anywhere else on the chart for that matter).

Is this possible and if so, any direction is most
appreciated!
 
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
add line to a stacked area chart already created Mitch Charts and Charting in Excel 3 April 3rd 23 04:43 PM
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 01:40 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 10:39 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"