The grids are at fixed intervals to provide a way to visualize the proportionality of the data. Scatter ChartĪ scatter, or XY, chart plots the X values proportionally. If the X value of the last point was 100, it still would be plotted at the same location as the 1.7. Notice that you get the actual X values displayed but every point is at an equal interval even though the X values are not. This treats the X values as categories and simply stacks the Y values next to each other at a uniform interval on the chart. If you aren't concerned with displaying the data proportionally on the X axis, you can use a line chart: That can't be done natively in Excel, and actually defeats the purpose of using a scatter chart. If I understand your problem correctly, it looks like you have data at an irregular interval, and you want to plot it as XY data but have the X axis grid lines match the X values of the data. (bottom left chart below).ĭelete the legend, and reformat the series along the X axis so it mimics an axis (medium gray line, cross markers using medium gray border and no fill). (top right chart below).įormat the data labels: Select the option to show Y values and deselect other options select the "below" position use a number format with one decimal digit. Excel adds Y value labels (all zero) above or left of the points. Select the series along the axis, and add data labels.
Best way is to use custom number format of " " (single space surrounded by double quotes), so there will be room for the data labels without having to manually adjust the plot area size. Make your chart with all the data (below left).Īdjust your axis as desired (below right). This will produce a series of data points along the horizontal axis. I know I would be distracted thinking, "Why did he choose to do that?" But people ask all kinds of questions.Īdd a column of data with all zeros. It's irregular not to show normal axis labels, because it may cause a lack of comprehension in whoever is reading the chart.
0 kommentar(er)
