Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Line Column on 2 axes that shows stacked colums
I am able to creat a line column graph on 2 axes. That shows $ as columns
and % as a line. However I wnat the colunms to be stacked colums. Can this be done? |
#2
|
|||
|
|||
Instead of using the built-in combination charts, you can create your
own. Jon Peltier has instructions on his web site: http://www.peltiertech.com/Excel/Cha...mboChart1.html To change your chart: Select the chart From the Chart menu, choose Chart Type Select the Column chart type Select the Stacked column subtype Click OK In the chart, select the series that you want as a line From the Chart menu, choose Chart Type Select the Line chart type Select one of the Line chart subtype Click OK Paul Henderson wrote: I am able to creat a line column graph on 2 axes. That shows $ as columns and % as a line. However I wnat the colunms to be stacked colums. Can this be done? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Create a stacked column chart for all the series. Then, in the chart
select the series you want as a line chart. With it selected, select Chart | Chart Type... and choose an appropriate line type. If you want, you can then move that line to the secondary axis. Double-click the series then select the Axis tab and pick 'Secondary Axis'. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?UGF1bCBIZW5kZXJzb24=?=" <Paul says... I am able to creat a line column graph on 2 axes. That shows $ as columns and % as a line. However I wnat the colunms to be stacked colums. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel |