ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Stacked Chart (per month per year) (https://www.excelbanter.com/charts-charting-excel/221344-stacked-chart-per-month-per-year.html)

M.ROD[_2_]

Stacked Chart (per month per year)
 
I'm trying to create a stacked chart consisting of this:
1.) x-axis showing 12 months of the year
2.) A stacked column for Sum 1, Sum 2 for year 2006
A stacked column for Sum 1, Sum 2 for year 2007
A stacked column for Sum 1, Sum 2 for year 2008
*Each sum is different

Basically, the chart should show 3 stacked columns per month for each year,
how can this be done?

Jon Peltier

Stacked Chart (per month per year)
 
Here's a tutorial:

http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"M.ROD" wrote in message
...
I'm trying to create a stacked chart consisting of this:
1.) x-axis showing 12 months of the year
2.) A stacked column for Sum 1, Sum 2 for year 2006
A stacked column for Sum 1, Sum 2 for year 2007
A stacked column for Sum 1, Sum 2 for year 2008
*Each sum is different

Basically, the chart should show 3 stacked columns per month for each
year,
how can this be done?





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

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