ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating a combination chart opportunity (https://www.excelbanter.com/charts-charting-excel/191208-creating-combination-chart-opportunity.html)

Stu

Creating a combination chart opportunity
 
I am trying to create a chart that consists of two bars. The first bar needs
to have multiple data ie. like a normal combination graph were the data is
visually split in one bar by different colors. The second bar is another data
set. I have never seen a chart set up this way, but wondering if possible and
the solution to this. I have read that I should try a custom user define, or
possibly set up first the combination graph and then add the second set of
data. However I have been unsucessful in getting the two rows of bars, it
always wants to put all three data sets into one row of bars. Thanks for
reading and your help.

Jon Peltier

Creating a combination chart opportunity
 
Check out this recent blog post:

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

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


"stu" wrote in message
...
I am trying to create a chart that consists of two bars. The first bar
needs
to have multiple data ie. like a normal combination graph were the data is
visually split in one bar by different colors. The second bar is another
data
set. I have never seen a chart set up this way, but wondering if possible
and
the solution to this. I have read that I should try a custom user define,
or
possibly set up first the combination graph and then add the second set of
data. However I have been unsucessful in getting the two rows of bars, it
always wants to put all three data sets into one row of bars. Thanks for
reading and your help.





All times are GMT +1. The time now is 08:17 AM.

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