How to automatically create a chart with multiple series in Excel?

Question

I want to create a scatter chart in Excel with dots only. I want each dot to be one series. Example of my data looks like this:

Legend Series	X-axis	Y-axis
300	0.0139	0.049
301	0.0166	0.119
310	0.0137	0.012
311	0.0111	0.107

I have not found an easy way to do this without having to put in manually one row at a time by creating a new series, but I am asking if there is a way to do this automatically (or something close to that). Should I put my data in some special order? I have tried the "paste special" function, but it did not give me the correct outcome.

Can you please help me? Thanks in advance.

Answer 1

This is as close as I can get

best wishes

Answer 2

If your data has nothing around it (no other data) just position the cursor anywhwere within the table;  otherwise select the data to be plotted.

On the Insert tab select the chart type you want.

NOTE: because the first column has numeric values, Excel will treat this as a data series except with an XY chart. You can avoid this by removing the Legend Series text at the top of the column. The text can be returned after making the chart.

best wishes

Answer 3

Thanks for the reply, are you saying that if my data looks like this:

A	0.0166	0.119
B	0.0137	0.012
C	0.0111	0.1

it will work? For me it does not. It creates two series, column 2 and 3, where x-axis is just a counter, i.e. A=1, B=2 & C=3.

Answer 4

This suggests you are making an XY chart which requires numeric values for the x-axis.

Make a Line chart with marker; right click one of the data series in the chart (e.g. the orange line) and use Format Data Series to specify No Line.

You could do the same thing with the next data series but the quick way is to click on it and press F4 which is the "Do that again, Sam" command!

best wishes

Answer 5

I feel like you are misunderstanding me. Maybe I wasn't clear from the start, but this is what I want (I added two series):

I made this manually by right clicking on the chart and selecting "Select Data" and then clicking "Add" under "Legend Entries (Series)". I had to do it 5 times, as I have 5 series. But I am looking for a quicker way, as my real data requires much more series on many charts.