![]() 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. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. 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. Select the data you want to plot in the scatter chart. This survey is all about Excel knowledge score out of 10 and the salary range for each Excel score. ![]() I.e., in the Scatter series, the data is X/Y pairs. Example 1 In this example, I am using one of the survey data. 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. 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). ![]() 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. This needs to be repeated for 35 countries so that we can merge all 5-column plots on one or two A4 pages. The Y axis should be values of the variables (0-100), with d1 to d5 adjacent to each other on the x axis so that we have 5 columns of points. Change the Scatter to a Line Chart, then format Line Color so that there is "No Line". I need to prepare a 'scatter' plot, as shown below, of say 5 variables (d1 to d5). This can be done by using a Scatter chart in Excel. I am trying to create an xy scatter plot on its own worksheet using VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |