Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default combine stacked bar charts

I am trying to combine 3 stacked bar charts into one chart. Everytime I try,
the data mixes up and doesn't come out correctly. Any suggestions?

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default combine stacked bar charts

Do you just want three series stacked upon each other? Make the chart with
all the data to begin with. If the data is not convenient to select all at
once, make the chart with some of the series data, then copy more data,
select the chart, and go to Edit menu Paste Special, and add the data as a
new series. Repeat as needed. If you need to, go to Chart menu Chart Type,
and reselect the stacked column type.

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


"yellowrigby" wrote in message
...
I am trying to combine 3 stacked bar charts into one chart. Everytime I
try,
the data mixes up and doesn't come out correctly. Any suggestions?



Reply
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
Can I combine a stacked bar with regular bars on the same chart? David Charts and Charting in Excel 5 April 20th 07 08:19 PM
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 02:44 AM
Can you combine an Excel Cluster Bar Graph with a Stacked Bar Grap matkinson Charts and Charting in Excel 2 January 28th 06 01:34 AM
How can I combine a stacked bar chart with stacked colum chart? Sin Charts and Charting in Excel 8 December 20th 05 03:50 AM
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


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

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

About Us

"It's about Microsoft Excel"