XY Scatter Chart Markers

[Jane]

I have an XY Scatter Chart with 100 entries. The data points plotted fine,
but the graph automatically assigned a different symbol and color to each
data point. To make the chart look cleaner, I wanted to make all of them the
same. I can select and change the data points individually, but it would
take a while. Is there any way to change them all at once?

Thanks,
Jane

 

[David Biddulph]

It sounds as if you've got 100 different series, rather than one series with
100 points which is what you want. What is the layout of the data in your
worksheet, and how did you produce the chart?

 

[Jane]

The original data set was 100 rows of data with the headers in the first
column, X values in the next column and Y values in the next. I couldn't
figure out how to make it work without transposing the X values so that they
appeared in the first row and there was a Y value only under the relevant X
value, so the data set ended up being 101 rows by 101 columns.