ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Two Data Sets: Stacked Column Chart (https://www.excelbanter.com/charts-charting-excel/233590-two-data-sets-stacked-column-chart.html)

Rainmaker

Two Data Sets: Stacked Column Chart
 
How do I show two years side-by-side in a stacked column chart? I want to
compare two "stacked" columns each month (one for each year). I can create
one showing each month for ONE year but I want to add another year in another
stacked column for each month. Can this be done?

Luke M

Two Data Sets: Stacked Column Chart
 
Yes, it can be done. It just takes some careful arrangement of data. See Jon
Peltier's excellent site on charting:

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

(depending on your browser, you may need to scroll down a bit to get to
beginning of article)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rainmaker" wrote:

How do I show two years side-by-side in a stacked column chart? I want to
compare two "stacked" columns each month (one for each year). I can create
one showing each month for ONE year but I want to add another year in another
stacked column for each month. Can this be done?



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

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