Two different y-axis scales?

C

Chris

Hello,

Is it possible in Excel to have different scales for two sets of data? I
want to show quantities and costs together in a column chart.

Thanks!
 
D

David Biddulph

Chris said:
Hello,

Is it possible in Excel to have different scales for two sets of data? I
want to show quantities and costs together in a column chart.
Click to expand...

Yes. Format Data Series/ Axis/ select secondary axis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two sets of intervals on Y axis 3
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
simple chart 0
Consolidation Table from Different Excel Tabs with Different Format 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Custom Format numbers for learning chart 0
Multiple independent x axis 1
How to insert 2 scales on y-axis? 3

Top