ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   stacked and clustered charts together (https://www.excelbanter.com/charts-charting-excel/220421-stacked-clustered-charts-together.html)

monstadunk

stacked and clustered charts together
 
I would like to make a chart that compares two categories against one other
category. So I need one column of a cluster chart to stack two series like a
stacked chart but then have a third series column placed next to the first
column. Ive gone into the script editor and used the best of my html
knowledge but im not getting exactly what i want. I am using excel 2003.
thanks for any help

smartin

stacked and clustered charts together
 
monstadunk wrote:
I would like to make a chart that compares two categories against one other
category. So I need one column of a cluster chart to stack two series like a
stacked chart but then have a third series column placed next to the first
column. Ive gone into the script editor and used the best of my html
knowledge but im not getting exactly what i want. I am using excel 2003.
thanks for any help


Have you tried placing the third series on the secondary value axis?

Jon Peltier

stacked and clustered charts together
 
Try this technique:

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


"monstadunk" wrote in message
...
I would like to make a chart that compares two categories against one other
category. So I need one column of a cluster chart to stack two series like
a
stacked chart but then have a third series column placed next to the first
column. Ive gone into the script editor and used the best of my html
knowledge but im not getting exactly what i want. I am using excel 2003.
thanks for any help





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

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