#WORDS FOR X AXIS 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. The position of each dot on the horizontal and vertical axis indicates values for. 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. Scatter plots are an essential type of data visualization that shows. 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.
![words for x axis scatter chart excel words for x axis scatter chart excel](https://www.excel-easy.com/smi/examples/scatter-plot.png)
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.
#WORDS FOR X AXIS SCATTER CHART EXCEL HOW TO#
So, Excel doesn't know how to plot your categories (columns) on an interval scale (the current X axis). 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. The short answer is that your combining (unsuccessfully) a categorical series (the columns) with interval/ratio series (the line charts). I.e., in the Scatter series, the data is X/Y pairs. For this scenario, we want a tick every two hours, for a total of 12 ticks on the X Axis. Next, we want to understand what date and time we want on the X Axis. Step 2: Check Categories in reverse order. Then, select the Format Axis from the context menu. To do this, we have to right click the y axis that we want to reverse.
![words for x axis scatter chart excel words for x axis scatter chart excel](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/06/24103600/1159.png)
The first thing we have to flip x and y axis is to select the Format Axis button. We get a scatterplot like below, but first we want to format some aspects of the graph. Flipping axis using the Format Axis dialog. The problem is summarized in this similar Q on SuperUser: Select Scatterplot Graphs Select Scatter. 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.
![words for x axis scatter chart excel words for x axis scatter chart excel](https://i.ytimg.com/vi/S4J3RW8wVOo/maxresdefault.jpg)
In the scatter chart, we can see that both horizontal and vertical axes indicated numeric values that plot numeric data in excel. Add axis labels to your horizontal axis by selecting the Layout tab of the Ribbon and clicking the Axis Labels drop-down box. Change the Scatter to a Line Chart, then format Line Color so that there is "No Line". A scatter chart in excel normally called an X and Y graph which is also called a scatter diagram with a two-dimensional chart that shows the relationship between two variables.