Granted, this does take a little bit of work, but it doesn't require editing every single data point. The x axis scale then changes to 0-100, which seems much more sensible.
In my case, I had your "NAMES" in Col A, and it used Col A as the source for the X axis values, which is obviously wrong.īut it's easy to change - just edit the source ranges for both the X and Y values. Then, for the remaining one, see where it's taking the X and Y values from - it's taking them from the wrong columns. You can simply select the second one and remove it. When you do this, you can see what's going wrong. To correct this, I opened the Chart dialog box, and selected the Source Data option. I used the chart wizard to knock up a quick XY chart, and sure enough, the X axis scale went from 0 to 10, which bears no relation to what you think are the X axis values. I'm not sure I understand your problem correctly, but if I do, there is a relatively easy fix, which does not require editing each data point.
0 kommentar(er)
