Charting - Custom Types

[pickslides]

When using the custom type "Line - Column on 2 axes"

Is there a way I can choose which series will go on which axes? Or should I ask is there a way I can assign Line or Column?

[Andy Pope]

If you want full control start by creating a chart of 1 type, say column. This will include all the series.
The select the series you want to change and change it's chart type to line.

[pickslides]

Hi Andy, Thanks for the reply.

Your suggestion is very helpful although I am keen to have 2 Y-axis'.

I should have mentioned this in my initial post.

Any further ideas on how to achieve this?

[Andy Pope]

Once you have 2 series you can select one of them and on the Format dialog set it to the secondary axis.

http://www.andypope.info/tips/tip005.htm

If you need more help post example of your current chart

[pickslides]

Perfect!

You're a star...