LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 271
Default How can I add a new axis as a line chart toa stacked bar chart

I have 5 months of data as a stacked bart chart - the Y-axis is the count of
orders that missed target due to a particular reason. So for month 1, there
are 100 misses across 5 categories; in month 2, there are 80 misses across
the same 5 categories etc. I want to add a new axis that shows the total
number ordered - missed or not. This total is always much higher so I'd like
to add it as a separate axis as a LINE that will show on top of the stacked
bar for each month. How can I do this?
 
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
2 axis chart stacked bar next to bar with line SuLu85 Charts and Charting in Excel 1 September 6th 07 02:18 AM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? lpenndorf Charts and Charting in Excel 1 February 7th 07 04:32 PM
How can I add a line chart in a stacked column chart style? Guilherme Loretti Excel Discussion (Misc queries) 0 August 3rd 06 01:46 AM
How do I do a combination STACKED column and line chart on 2 axis rwtuning Charts and Charting in Excel 1 April 18th 06 10:02 PM
How do I add a line chart to a stacked chart? smazeika Charts and Charting in Excel 4 May 27th 05 03:26 AM


All times are GMT +1. The time now is 05:05 PM.

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"