Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Haynesz
 
Posts: n/a
Default Flip the X and Y data on a chart so that the Y data is vertical.

I'm new at creating charts and it seems that no matter how I arrange the 3
columes of data the smaller number one ends up on the bottom. I have 1 colume
of vacuum levels(0 to 28) I want on the vertical and 2 columes of degree of
rotation to appear on the horizontal(0 to 360).
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Excel's very good at making charts with multiple series quickly if they share their
X values. You want to share their Y values.

Put the two rotation columns first, followed by the vacuum column. Select the first
rotation column, then hold CTRL while selecting the vacuum column. Start the chart
wizard, select XY Scatter in the first step, then in the second step, click on the
Series tab, click Add, click in the Y Values entry field and select the Vacuum range
again, then click in the X Values entry field and select the second rotation column,
and press Finish.

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

Haynesz wrote:

I'm new at creating charts and it seems that no matter how I arrange the 3
columes of data the smaller number one ends up on the bottom. I have 1 colume
of vacuum levels(0 to 28) I want on the vertical and 2 columes of degree of
rotation to appear on the horizontal(0 to 360).


Reply
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 can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Formulas in source data Ken Charts and Charting in Excel 3 December 1st 04 05:43 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM
Bar Chart for Text Data RichIII Charts and Charting in Excel 1 November 29th 04 07:03 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"