LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Secondary X-axis with reverse Y-axis

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
Secondary Axis Ann Charts and Charting in Excel 5 October 21st 05 09:38 AM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"