ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I use side by side colums and stacked columns in same graph? (https://www.excelbanter.com/charts-charting-excel/249-can-i-use-side-side-colums-stacked-columns-same-graph.html)

Debbie

Can I use side by side colums and stacked columns in same graph?
 
I have a completed graph that shows side by side columns and a line, but I
would like to add a stacked column to the graph without losing the other side
by side columns.

Jon Peltier

Debbie -

You need a stacked-clustered column chart. This page has links that show how to
accomplish such a chart. Most likely you'll have to rearrange the data and make a
new chart.

http://peltiertech.com/Excel/ChartsH...sterStack.html

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

Debbie wrote:

I have a completed graph that shows side by side columns and a line, but I
would like to add a stacked column to the graph without losing the other side
by side columns.




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

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