If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
two x axes with one y axis, different data on x
I need to have two x-axis with two different types of data (ex: oxygen and
temp, one on top, one on the bottom) with one y-axis (depth, on the left). The same basic concept as having 2 y-axes but with the x-axes. |
#2
|
|||
|
|||
two x axes with one y axis, different data on x
Make your XY chart with both sets of data. Double click one series, and on
the Axis tab, select Secondary. Excel helpfully gives you a secondary Y axis, but only the primary X axis. Select Chart Options from the Chart menu, and on the Axes tab, uncheck the secondary Y box, and check the secondary X box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Kris@Cooper" wrote in message ... I need to have two x-axis with two different types of data (ex: oxygen and temp, one on top, one on the bottom) with one y-axis (depth, on the left). The same basic concept as having 2 y-axes but with the x-axes. |
#3
|
|||
|
|||
two x axes with one y axis, different data on x
Thanks, i also found the xy switch add-on which moved my depth data to the
y-axis and then everything was fixed when i did what you suggested below. Thanks "Jon Peltier" wrote: Make your XY chart with both sets of data. Double click one series, and on the Axis tab, select Secondary. Excel helpfully gives you a secondary Y axis, but only the primary X axis. Select Chart Options from the Chart menu, and on the Axes tab, uncheck the secondary Y box, and check the secondary X box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Kris@Cooper" wrote in message ... I need to have two x-axis with two different types of data (ex: oxygen and temp, one on top, one on the bottom) with one y-axis (depth, on the left). The same basic concept as having 2 y-axes but with the x-axes. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting a new line when external data changes | Rental Man | General Discussion | 0 | January 11th, 2006 08:05 PM |
cross office program data sharing | m_jurrens | General Discussion | 0 | December 16th, 2005 04:36 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I put a gap between 2 data sets on the x axis? | Jon Peltier | Charts and Charting | 1 | April 19th, 2004 12:57 AM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |