ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   combine stacked bar charts (https://www.excelbanter.com/charts-charting-excel/142721-combine-stacked-bar-charts.html)

yellowrigby

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?


Jon Peltier

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?





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com