Scatter chart displays as line chart

G

Guest

I'm trying to connect point on a (background graphic) circle with lines
(using Excel 2000). I have generated the X-cordinates for all ends of lines
in one column and, in each of the following columns, I have the Y-cordinates
for one line, two values next to each other; in the same rows as their
X-coordinates. All other cells are empty.

This works in smaller scale but when I have 250 lines, the X-values are
replaced with rising numbers, i.e. I get a line graphic.

Is there any way to make the scatter graphic work in large scale figures?

Thanks
 
A

Andy Pope

Hi,

Have you used the xy-scatter type of chart or is it a Line chart.
Line charts have categorical x axis where as xy-scatter charts has true
value axis.

Cheers
Andy
 
M

Mike Middleton

Hannu -

For an XY (Scatter) chart type, if even just one of the cells of the X range
is not numeric (e.g., the cell contains text that looks like a number), then
Excel reverts to a Line chart type (equally spacing the X values on the
horizontal axis and using 1,2,3,... for trendline X values).

- Mike
www.mikemiddleton.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

Top