How do I make a combination chart in 2007 as in 2003?

[Ducky]

Cannot work out how to make a simple combination graph like it was easy to do
in 2003. Doesn't seem to be any help on this.

 

[Andy Pope]

Hi,

Combination charts are still possible in xl2007. But the default ones
presented in xl2003 have gone.
Basically you have to create the combination yourself.

Create the chart in the style that most series will be. Then selected a
series that you want to change the chart type of and then press the Chart
Type button in the Change Chart Type button within the Type Group in the
Design tab of the Chart Tools contextual tab.

Cheers
Andy

 

[Shane Devenshire]

Hi,

Your question also implies that you are after a dual axis chart, no?

If so:
Choose one of the series and then click the Format tab, choose Format
Selection, and under Series Options choose Secondary Axis. Repeat for each
series you want on that axis.

Cheers,
Shane