Thread: Charting - Custom Types

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?

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.

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?

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

Perfect!

You're a star...