x and y axis

#1 September 9th, 2004, 07:15 PM

I am trying to do a line chart and I have the y axis information where the x
axis information should be and the x information where the y information
should be. How can i make the y and x axis switch places?
-smq

#2 September 10th, 2004, 12:45 AM

smq -

I am trying to do a line chart and I have the y axis information where the
x axis information should be and the x information where the y information
should be. How can i make the y and x axis switch places?

Select the chart. Choose Chart | Source Data | Series, and respecify the
ranges for the X and Y values.

- Mike

www.mikemiddleton.com

#3 September 10th, 2004, 03:10 AM

If it's an XY Scatter chart, you can use this little utility:

http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

smq wrote:
I am trying to do a line chart and I have the y axis information where the x
axis information should be and the x information where the y information
should be. How can i make the y and x axis switch places?
-smq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with the display of a 2 axis chart	Peter B	Charts and Charting	1	August 4th, 2004 02:39 AM
Two Y axis in Graph	Debra Dalgleish	Charts and Charting	0	March 20th, 2004 09:39 PM
force graph to axis of choice	Tushar Mehta	Charts and Charting	3	February 11th, 2004 04:04 PM
Logarithmic X Axis in PivotChart.	Nashhol	Charts and Charting	0	October 21st, 2003 04:39 PM
Format Axis	Andy Cave	Charts and Charting	1	October 6th, 2003 02:56 PM