If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I combine a stacked column chart and line chart?
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? |
#2
|
|||
|
|||
How can I combine a stacked column chart and line chart?
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Huib" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|