Excel chartting need help with x axis

B

Blunt

I have two columns of paired data that I am trying to chart. I highlight the
range of both columns and then F11 and it plots both and creates values for
the x axis. I want the first column to be the x axis... I don't want to plot
it. Can't figure it out...what am I doing wrong?
 
J

Jon Peltier

Select the range, start the chart wizard (choose Chart from the Insert
menu, or click on the little Chart icon on the toolbar), and in the
first step of the wizard, select an XY Scatter chart.

If you want a Line chart, select the XY Scatter chart type with markers
and lines.

If you don't want a scatter (or line) chart, put a label in the cell
over the Y values, and leave the cell over the X values blank. (You are
putting the X values to the left of the Y values, right?) Now clicking
F11 will use the columns as you intend, because the blank cell tells
Excel the columns are different, and one is the categories.

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

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

Scatter chart with categories on x-Axis 2
Finding asymptote equation and how to draw them in excel 0
simple chart 0
Make Y-axis values correspond to x- axis value 1
One extra x axis item that wont go away - can anyone help? 3
change chart primary horizontal axis label or name 1
A line chart 3
Chart distorts secondary axis when the x-axis is logarithmic 5

Top