Hi

I need to biuld a graph that works of two axes as a bar and a line chart so that I can compare two peices or data that correlate to each other but have different scales.

This isnt available in my graph options but I have used it before on previous computers as a template so think I need to build it as a new template.

How do I do this?

Thanks

Lyndsey

Hi Lyndsey,

Thanks for your question.

I am not sure if it is necessary to create a template for this case. But try the following steps first:

1. Select all the graph data
2. Select Chart Wizard
3. On Step 1: Chart Type, switch tab to "Custom Types"
4. Scroll down the list for "Line - Column on 2 axes"
5. Press NEXT and follow the rest of the wizard to create the chart

See if this is the result you want, if not I still have another way to achieve this.

Regards,

Katie Woo
Microsoft Certified Trainer