Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D column chart, stacked | Charts and Charting in Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Column Chart | Charts and Charting in Excel | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Copying the contents of a column into a chart | Excel Worksheet Functions |