Direct XY Scatter plot using series

[samuelalfred]

Hello,

I want to be able to generate a scatter plot directly, by just selecting the data I want to plot and select which chart type I want. No further settings should be neccessary. This is because I am generating an Excel Worksheet from another program and therefore it all has to be done automatic.

The data I want to plot consists of three series with three X-Y pairs. However, the X-values are not the same in the three series why I have to organize the data as can be seen in the attached file (X values to the left, series at the top, Y values the rest).

The problem is when I select the data and plot is as a XY Scatter plot, there are empty cells (since there are no Y-values for some X-value in each series) in each series which results in breaks in the lines in the plot. For instance, in the series called 15 there is not a line between 30 and 72 (since that series does not have an Y-value for X=80). Look in the attached file for clarification.

Is there any way to tell Excel to skip the empty cells and just interpret the data as three X-Y values for each series? Or should I organize the data in another way to get a satisfying result (which is three lines, one for each series)?

Thank you in advance!
Best regards,
Samuel Alfredsson

[Andy Pope]

Select the chart
Tools > Options > Chart > Plot empty cells > Interpolated