| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two different y-axis scales?
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! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Two different y-axis scales?
"Chris" wrote in message
... 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. Yes. Format Data Series/ Axis/ select secondary axis. -- David Biddulph |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Two different y-axis scales?
Hi,
Have a look at Jon's page. With columns it is not just as simple as changing the axis as columns on the secondary axis will cover those on the primary. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html Cheers Andy Chris wrote: 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! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Two different y-axis scales?
Thanks!
Chris "Andy Pope" wrote: Hi, Have a look at Jon's page. With columns it is not just as simple as changing the axis as columns on the secondary axis will cover those on the primary. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html Cheers Andy Chris wrote: 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! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Stacked AND Clustered AND Different axis scales | Charts and Charting in Excel | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| "Broken" chart axis for data of different scales | Charts and Charting in Excel | |||
Linear Mode
