ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dual Bar Chart (https://www.excelbanter.com/charts-charting-excel/231250-dual-bar-chart.html)

Ingo

Dual Bar Chart
 
I have a simple table with Sales, several Cost-categories and Result per
month over one year. How do I create two columns per month, one for Sales and
one for the Cost-catergories, so that the difference in hight of these two
columns represent my Result per month?

Jon Peltier

Dual Bar Chart
 
Perhaps you want a clustered-stacked column chart?
http://peltiertech.com/WordPress/clu...column-charts/

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Ingo" wrote in message
...
I have a simple table with Sales, several Cost-categories and Result per
month over one year. How do I create two columns per month, one for Sales
and
one for the Cost-catergories, so that the difference in hight of these two
columns represent my Result per month?





All times are GMT +1. The time now is 06:29 AM.

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