LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How do I set up a stacked chart with different series for each bar

Maybe you need to switch between By Rows and By Columns. That is found from
the Chart menu Source Data Data Range tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Virent" wrote in message
...
I am trying to create a stacked chart for three different products (Product
A, B, C). Each product has three different values that make up the
product's
cost (Cost A, B, C). The products need to be compared at different
values.
So, compare total cost (based on sum of Cost A, B, C) of Product A, B, C
at
$5. Then compare their total cost at $10. Then at $20. How do I do this
without having a separate X Value (5,10,20) for each bar? I want Products
A,
B, C to have the same X Value of $5, without seeing $5 three different
times.
Thank you.



 
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
Chart will not display complete series Doug Charts and Charting in Excel 1 November 7th 05 03:29 PM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
How to change Series Order in a Combination Chart? vrk1 Excel Discussion (Misc queries) 0 March 31st 05 11:19 PM
Dynamic series in Chart Jeff Charts and Charting in Excel 2 February 24th 05 11:54 AM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 05:56 AM


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