Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 2 secondary y axis with individual ranges of value
Hi All,
I work with electric motors which have several different value ranges i would like on a single chart, namely; Speed, Power, Current and Efficiency, with thier own Y axis, and all plotted against Torque on the X axis. I need seperate Y axis as the ranges are all different, e.g. Speed = 0 - 4000rpm, Efficiency = 0-85%, Current = 0-20Amps, Power = 0-150Watts for example. At the moment i can only get 2 different Y axis values, I need 4! Can anyone help? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 2 secondary y axis with individual ranges of value
Hi,
You will need to construct you own additional Y axis. For more information have a look at http://peltiertech.com/Excel/Charts/TertiaryAxis.html http://www.processtrends.com/pg_glob...climate_Trends Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Big G" <Big wrote in message ... Hi All, I work with electric motors which have several different value ranges i would like on a single chart, namely; Speed, Power, Current and Efficiency, with thier own Y axis, and all plotted against Torque on the X axis. I need seperate Y axis as the ranges are all different, e.g. Speed = 0 - 4000rpm, Efficiency = 0-85%, Current = 0-20Amps, Power = 0-150Watts for example. At the moment i can only get 2 different Y axis values, I need 4! Can anyone help? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 2 secondary y axis with individual ranges of value
The technique should be expandable. Basically you are drawing your own axis.
Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Big G" wrote in message ... Hi Andy, Thanks for the info, looks very thorough!! - Will have a go in a bit, do you know if the same technique can be used to add a fourth axis?!?!? - using the Peltiertech method. Thanks Again "Andy Pope" wrote: Hi, You will need to construct you own additional Y axis. For more information have a look at http://peltiertech.com/Excel/Charts/TertiaryAxis.html http://www.processtrends.com/pg_glob...climate_Trends Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Big G" <Big wrote in message ... Hi All, I work with electric motors which have several different value ranges i would like on a single chart, namely; Speed, Power, Current and Efficiency, with thier own Y axis, and all plotted against Torque on the X axis. I need seperate Y axis as the ranges are all different, e.g. Speed = 0 - 4000rpm, Efficiency = 0-85%, Current = 0-20Amps, Power = 0-150Watts for example. At the moment i can only get 2 different Y axis values, I need 4! Can anyone help? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 2 secondary y axis with individual ranges of value
Much better than cluttering up things with a tertiary axis (& quaternary
axis etc.) is to make panel charts instead: http://peltiertech.com/Excel/Charts/StackedCharts.html http://peltiertech.com/Excel/ChartsH...nelChart1.html http://peltiertech.com/Excel/Comment...DayOfYear.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, You will need to construct you own additional Y axis. For more information have a look at http://peltiertech.com/Excel/Charts/TertiaryAxis.html http://www.processtrends.com/pg_glob...climate_Trends Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Big G" <Big wrote in message ... Hi All, I work with electric motors which have several different value ranges i would like on a single chart, namely; Speed, Power, Current and Efficiency, with thier own Y axis, and all plotted against Torque on the X axis. I need seperate Y axis as the ranges are all different, e.g. Speed = 0 - 4000rpm, Efficiency = 0-85%, Current = 0-20Amps, Power = 0-150Watts for example. At the moment i can only get 2 different Y axis values, I need 4! Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |