| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Bar and Line on Same Graph
Hi
Is it possible to produce, on a single graph, a stacked bar chart and a line chart with left vertcal axis showing bar scale and right vertical axis showing line scale. .... heres hoping ... John |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked Bar and Line on Same Graph
Hi,
Assuming you mean column (vertical) rather than bar (horizontal). Create the stacked column chart based on all the series. Select series you want as line and via the right-click context menu change the chart type to line. Then format the line to use the second axis via the format dialog - scale tab. If you really did mean bars then the line chart needs to be a xy-scatter. Cheers Andy JohnAmcorF wrote: Hi Is it possible to produce, on a single graph, a stacked bar chart and a line chart with left vertcal axis showing bar scale and right vertical axis showing line scale. ... heres hoping ... John -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked Bar and Line on Same Graph
Hi Andy
Many thanks for the quick response - this is just what I wanted John "Andy Pope" wrote: Hi, Assuming you mean column (vertical) rather than bar (horizontal). Create the stacked column chart based on all the series. Select series you want as line and via the right-click context menu change the chart type to line. Then format the line to use the second axis via the format dialog - scale tab. If you really did mean bars then the line chart needs to be a xy-scatter. Cheers Andy JohnAmcorF wrote: Hi Is it possible to produce, on a single graph, a stacked bar chart and a line chart with left vertcal axis showing bar scale and right vertical axis showing line scale. ... heres hoping ... John -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a stacked bar graph? | Charts and Charting in Excel | |||
| Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
| Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
| Stacked Bar graph | Excel Discussion (Misc queries) | |||
| How do i add a line graph onto a stacked column chart using data | Charts and Charting in Excel | |||
Linear Mode
