Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart : 2 axes stacked bar and line
how to :
2 axes stacked bar and line graph i've been trying to figure this out - but it only lets me do a normal bar and line graph - NOT stacked bar aaaaaaaarrrgh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart : 2 axes stacked bar and line
Hi,
Ignore the combination charts offered and create your own. Start with a stacked bar chart based on all your data. Select the series you want to plot as a line and right click. On the context menu pick Chart Type. Select required line type. If it is not automatically placed on the secondary axis double click the line series and on the Axis tab change to the secondary axis. If you meant horizontal bars rather then vertical columns you can still do the combination but you will need to use xy-scatter instead of line chart. And obviously you will need to supply the X and Y values. Cheers Andy gabby wrote: how to : 2 axes stacked bar and line graph i've been trying to figure this out - but it only lets me do a normal bar and line graph - NOT stacked bar aaaaaaaarrrgh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked/clustered column chart with a two vertical axes | Charts and Charting in Excel | |||
Line column on 2 axes - stacked columns data not stacking | Charts and Charting in Excel | |||
Two-Axes, Stacked and Line Chart | Charts and Charting in Excel | |||
how do I create a chart on two axes with stacked columns and line | Charts and Charting in Excel | |||
Line Column on 2 axes that shows stacked colums | Charts and Charting in Excel |