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