Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Formulas in source data | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Bar Chart for Text Data | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |