Custom Excel Chart - Stacked Column and Line 1

[DrBowes]

Not sure if this can be done using XL2k.

Would like to have a stacked bar chart with a line as well. I am able to combine bar chart and line chart but not have stacked bars.

The stack bars will be the achieved volumes of business broken down into categories by month, and the line represents the target. (The target is only a total, not based on the categories the make up the actuals.)

Any suggestions most welcome. Cheers

 

[SkipVought]

DrBowes,

In the Chart, select the SERIES that you want to change.

Chart/Chart Type - and select the Chart Type you want for this series.

If your need a SECONDARY AXIS for this series, select the series, Format/Selected Data Series - Axis tab and select secondary axis.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DrBowes]

Hats off to you sir!

Would give two stars if I was allowed....