Column Chart With Averages Displayed
I'm trying to create a "100% Stacked Column" chart with the Averages for each
series added in as a secondary axis. So I'm basically trying to create a combination chart, with primary axis being the 100% Stacked Column chart and the secondary axis being a scatter plot of the average. Anyone have any ideas? Thanks. -- Regards, Dave |
Column Chart With Averages Displayed
I'd probably just be content with a line series for the average, and not
deal with the different X axis types. Calculate the averages in the worksheet, and add this range to the chart as a new series. Excel will very helpfully add it as another brick in the wall, so select the new series, and using Chart Type on the Chart menu, change it to a line type. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "David Billigmeier" wrote in message ... I'm trying to create a "100% Stacked Column" chart with the Averages for each series added in as a secondary axis. So I'm basically trying to create a combination chart, with primary axis being the 100% Stacked Column chart and the secondary axis being a scatter plot of the average. Anyone have any ideas? Thanks. -- Regards, Dave |
All times are GMT +1. The time now is 04:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com