ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Stacked Chart - Side By Side (https://www.excelbanter.com/charts-charting-excel/74673-stacked-chart-side-side.html)

Ken

Stacked Chart - Side By Side
 
Hey everyone,

Does anyone know if there is a way to get a stacked chart side by side? For
example, you have airplanes, cars and trains on the x axis and values of
2005, 2006, 2007 and 2008. I know you can have all these values in one bar
but is it possible to have two stacked bars for one x-value? For example,
for airplanes, you have one bar with 2005 and 2006 and a bar next to it with
the 2007 and 2008 values.

Thanks, appreciate your help.

Jon Peltier

Stacked Chart - Side By Side
 
Try one or more of these links:

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

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

"Ken" wrote in message
...
Hey everyone,

Does anyone know if there is a way to get a stacked chart side by side?
For
example, you have airplanes, cars and trains on the x axis and values of
2005, 2006, 2007 and 2008. I know you can have all these values in one
bar
but is it possible to have two stacked bars for one x-value? For example,
for airplanes, you have one bar with 2005 and 2006 and a bar next to it
with
the 2007 and 2008 values.

Thanks, appreciate your help.





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

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