x-y plot in Excel 2007 questions

J

jacketsfan33

I am trying to make an x-y plot and the axis that excel uses are not what I
want. I am comparing wages to 3 different outputs. I want wages on the
y-axis and output on the x-axis, but excel does the opposite. I went to
"select data" and did "switch row/column" and did not get the results that I
am wanting. So my question is, how do I tell excel what I want on the x-axis
and y-axis?
 
B

Bernard Liengme

The simplest way: You put the x-values in one column and the y-values in a
column to the right. You make the chart from this data

Or with the 'wrong' chart.Right click and use Data Source; In the dialog
change the entries for the x and y values.

Changing row/col is saying the data is in row not columns

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I put words as the Y axis values? 0
Make Y-axis values correspond to x- axis value 1
Switching X and Y axis 4
X-Axis Appearing in Plot Area 2
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
X Y (Scatter) Chart EXCEL 2007 1
Plot a time series on the x-axis and categories on the y-axis 3

Top