Scatter Diagrams

G

Greener2224

The x values will not display properly. They just plot as if they were the
numbers 1 2 3 etc but the y values are fine.
If I make the reverse the x and y data the graph works but is of course not
in the format I want
Suggestions please
 
J

Jon Peltier

Use the XY chart type, not the line type, and make sure the chart is using
the X data.

- Jon
 
G

Greener2224

I was using the xy chart but the x values were not plotting correctly the
were acting as if the wer the numbers 1,2,3,4.....
 
J

Jon Peltier

Make sure the chart is using the correct data for its X values.
Make sure these data are truly numeric, and not numbers stored as text.

- Jon
 
G

Greener2224

Done all of that if I reverse my selection of data for x and y the graph
works perfectly but has the wrong orientation
 
J

Jon Peltier

Okay, I'll bite. Send a copy of the errant worksheet to me in an email to

jonxlmvp at peltiertech dot com

I'll take a look.

- Jon
 

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

Non Linear Scatter plot, need to find y value 3
problem with scatter diagram excel 2007 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Plotting Graph with dynamic table 3
Make Y-axis values correspond to x- axis value 1
Mail Merge Problem 1
Use text descriptors as Y axis units 1
Charting scientific data - Excel 2003 5

Top