Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
3rd Y Axis
I am charting the passage of a low pressure system. On the primary Y axis I am plotting Barometric Pressure as a line chart with values between 28 and 31 inches of mercury. On the secondary Y axis I am plotting Wind Speed, Wind Gusts and Temperature, also as line charts, with values between 0 and 55 MPH/ºF. I am also using the secondary axis to plot as an area chart the elevation of the Sun between 0º and 30º. All of that is working fine and looks OK. Now I want to add a scatter chart of wind direction. It will need to have values between 0 and 345 so I can’t plot it against either the primary or secondary Y axis. Is it possible (without using VB which I don’t know anything about) to add a third Y axis to the chart? If I can add the axis, can I have it evaluate the direction in degrees but have it display the direction in compass points (N, NE, E, SE…) on the axis? If I can’t add a third Y axis to my existing chart, is there a way of adding a second chart beneath the first one that will be in the same big box and share the same title, legend, etc. as my existing chart? -- caridgway ------------------------------------------------------------------------ caridgway's Profile: http://www.excelforum.com/member.php...o&userid=29914 View this thread: http://www.excelforum.com/showthread...hreadid=496124 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
3rd Y Axis
See http://peltiertech.com/Excel/Charts/TertiaryAxis.html
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "caridgway" wrote in message ... I am charting the passage of a low pressure system. On the primary Y axis I am plotting Barometric Pressure as a line chart with values between 28 and 31 inches of mercury. On the secondary Y axis I am plotting Wind Speed, Wind Gusts and Temperature, also as line charts, with values between 0 and 55 MPH/ºF. I am also using the secondary axis to plot as an area chart the elevation of the Sun between 0º and 30º. All of that is working fine and looks OK. Now I want to add a scatter chart of wind direction. It will need to have values between 0 and 345 so I can’t plot it against either the primary or secondary Y axis. Is it possible (without using VB which I don’t know anything about) to add a third Y axis to the chart? If I can add the axis, can I have it evaluate the direction in degrees but have it display the direction in compass points (N, NE, E, SE…) on the axis? If I can’t add a third Y axis to my existing chart, is there a way of adding a second chart beneath the first one that will be in the same big box and share the same title, legend, etc. as my existing chart? -- caridgway ------------------------------------------------------------------------ caridgway's Profile: http://www.excelforum.com/member.php...o&userid=29914 View this thread: http://www.excelforum.com/showthread...hreadid=496124 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |