Line-Column on 2 Axes Chart Mac Version 11.1

[amelia.taylor]

The chart type 'Line-Column on 2 Axes' is available using PC versions
of excel.

I am using Excel 2004 for Mac Version 11.1 and can't find the chart
option.

Is there another way to create the same sort of chart or is it
something to do with how Excel has be installed

Any ideas would be greatly appreciated.

Thanks

 

[JE McGimpsey]

The chart type 'Line-Column on 2 Axes' is available using PC versions
of excel.

I am using Excel 2004 for Mac Version 11.1 and can't find the chart
option.

Is there another way to create the same sort of chart or is it
something to do with how Excel has be installed

Any ideas would be greatly appreciated.

Combination charts are easily customized - the built-in options are just
shortcuts, and WinXL and MacXL have different sets. But most combos can
be achieved on each platform.

For example, start with the Line chart on 2 axes custom type. Select a
series that you want to show as a column chart. CTRL-click the series
and choose Chart Type... from the pop-up menu. In the Chart Type dialog,
select the Standard Types tab. Note the Options checkbox to "Apply to
selection" is checked. Choose "column", then click OK. Repeat for other
series you want as columns.

You now have a Line-Column on 2 Axes chart.

 

[amelia.taylor]

Fantastic!!!

Thanks really helped me out.

Very much appreciated.