| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine a stacked and clustered column chart in Excel | Charts and Charting in Excel | |||
| How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
| How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
| Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
| How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
Hybrid Mode
