How to scatter chart excel series#
The x-axes are not aligned because they are not the same data or even the same type of data!Īll that said, if you change both series to XY Scatter, it is possible (with some extraordinary effort) to apply shading/coloring below a series or between two series, etc. So even though the two series appear to share the same set of X-Values, the Chart is simply incapable of treating those as the same type of data. The problem I have is that the x-axis values of the two series are not aligned. But in your Area chart, it treats the X-values as categorical, and in this context "1.1" is no different than "Bob" - it is a cardinal representation of the data rather than an ordinal representation. I.e., in the Scatter series, the data is X/Y pairs.
![how to scatter chart excel how to scatter chart excel](https://i.ytimg.com/vi/ySdGUcyUe8U/maxresdefault.jpg)
Without making any changes to the axes configuration, the second X-axis will now appear along the bottom of the chart, and you can see it is scaled differently from your Scatter data. You can verify this by selecting Chart > Layout > Axes > Secondary Horizontal Axis > More Secondary Horizontal Axis Options.
How to scatter chart excel how to#
So, Excel doesn't know how to plot your categories (columns) on an interval scale (the current X axis).
![how to scatter chart excel how to scatter chart excel](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/02/Scatter-Chart-in-Excel.jpg)
Select the data you use, and click Insert > Insert Line & Area Chart > Line with Markers to select a line chart. Actually, there is no way that can display text labels in the X-axis of scatter chart in Excel, but we can create a line chart and make it look like a scatter chart. Right-click on one of the dots in the chart and select Change Series Chart Type. Display text labels in X-axis of scatter chart. Excel will create a chart that looks like this: Step 11: Right-click on one of the dots in the chart and select Change Series Chart Type.
![how to scatter chart excel how to scatter chart excel](http://diagrammm.com/img/social/scatter-plot.png)
The short answer is that your combining (unsuccessfully) a categorical series (the columns) with interval/ratio series (the line charts). In the top ribbon, select Insert > Charts > Scatter. The problem is summarized in this similar Q on SuperUser: There may be another way to do this while retaining the Scatterplot, I'm not sure, but this seems to be visually what you're looking for, but I think you will need to use a Line Chart for this unfortunately. Change the Scatter to a Line Chart, then format Line Color so that there is "No Line".