How can I combine a stacked column chart and line chart?

H

Huib

I want to combine a standard stacked column chart with a line that, for
example, presents the average value of stacks in each column. This is only
possible by drawing manually a line in the stacked column chart, or is there
a better trick?
 
A

Andy Pope

Hi,

Create your stacked column chart using all the data.
Select the series that contains the average data. Change the series chart
type to Line.

Cheers
Andy
 

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

Filtered view of Visio Chart 0
Sorting a stacked column 0
sideways stacked bar charts with line series on the same axis 0
Creating Network Diagram using a Chart SW integration 0
Stacked Bar Chart 1
Create a chart from a table in word thats dynamic 0
Total of Stacked Column Chart 1
Can Excel produce a clustered and stacked column chart? 2

Top