Column Chart With Averages Displayed

G

Guest

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.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stacked column graph adjacent to a regular column graph 0
Pivot Chart Refresh cancels all chart formatting 2
secondary category axis reset to min=0 max=0 on save 1
Combination chart: primary data labels obscure line series on secondary axis 3
How do I combine stacked and clustered chart types? 2
Stacked Chart (per month per year) 1
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? 2

Top