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.
Step 4: Add the axis titles, increase the size of the bubble and Change the chart title as we have discussed in the above example. Step 3: This will create the scatter diagram. 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. Step 2: Go to Insert > Chart > Scatter Chart > Click on the first chart. For a Bar chart the Category and Value axes are reversed: A Scatter chart (but not a Line chart) has 2 value axes: Date Category Axes are a special type of category axis that give them some of the properties of values axes such as min and max when used with date or time values. 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. 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.
#Scatter chart excel triangle not centered how to
So, Excel doesn't know how to plot your categories (columns) on an interval scale (the current X axis). The short answer is that your combining (unsuccessfully) a categorical series (the columns) with interval/ratio series (the line charts). 2) click on the legend entry you want to delete so that only that entry is selected. You can remove individual entries from the legend by: 1) click on the legend to select the legend. Notice that we do not include the totals in our data series. The problem is summarized in this similar Q on SuperUser: Re: Scatter chart with colors and shapes based off of values. Outlined in red, the image below shows the three data series were charting. 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".
0 kommentar(er)
