Forum Discussion
Solved
Quickly creating a x-y scatter chart with straight lines and markers
I have a large number of data series with annual data returned. I would like to quickly create an X-Y scatter chart with lines and markers with one line for each series, with values returned on the y...
Select the range.
Insert a scatter chart with lines and markers.
If it looks wrong, click anywhere in the chart.
On the Chart Design tab of the ribbon, click Switch Row/Column.
Here is an example. First, the scatter chart as created by Excel:
Next, the result of clicking Switch Row/Column:
It needs a bit more work - we don't want 2017.5 etc., so we format the X-axis:
Select the range.
Insert a scatter chart with lines and markers.
If it looks wrong, click anywhere in the chart.
On the Chart Design tab of the ribbon, click Switch Row/Column.
Here is an example. First, the scatter chart as created by Excel:
Next, the result of clicking Switch Row/Column:
It needs a bit more work - we don't want 2017.5 etc., so we format the X-axis:
thank you - great response.