![]() |
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. |
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