In article <1109843873.978719.306150 RemoveThis @o13g2000cwo.googlegroups.com>,
amelia.taylor RemoveThis @gratterpalm.co.uk wrote:
> 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.<!-- ~MESSAGE_AFTER~ -->
>> Stay informed about: Line-Column on 2 Axes Chart Mac Version 11.1