Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
HI guys just wandering if anyone can me with this problem. this is my set of
data x1 y2 x2 y2 x3 y3 2.7 9.4 30.7 100.1 1.275 9.4 5.6 25.5 33.6 90.7 1.325 25.5 8.0 39.4 39.3 74.6 1.375 39.4 10.1 51.1 45.5 60.7 1.425 51.1 Plotting. Set data 1 ( x1,y1 ) = plot with reverse Y value Set data 2 ( x2,y2 ) = plot with normal Y value Set data 3 ( x3,y3) = plot with reverse Y value, need secondary axis I have been succesfull to plot all the data, except when i have to use the secondry X-axes ( set data 3 ) i know there has been suggestion about " go to chart option and change it to secondary x-axis, but the problem is because i have revese the Y value, the X - axis swap to the top make it unable to have secondary axis what happen when i " tick" secondary axis, my primary X-axis will dissapear........please help me excel expert.......... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Secondary Axis | 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 | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |