[Solved] Chart x-axis scale not scaling chart data

[edge333]

When I change the scaling on the x-axis of a chart, the x-axis numbers change but the corresponding xy scatterplot data does not change with the new scale and remains positioned in the same place. For example if my x-axis started at 8 and ended at 26 with a data point at 10 and I changed the scaling so that it started at 0 and ended at 30, the data would not be at ten but would instead be in the same position hovering around 4 on the new scale. Why is this happening?

[Villeroy]

Make shure that you have a x/y-scatter rather than a line chart.
The column keeping the x-values must be numeric rather than numeric text. Ctrl+F8 toggles value highlighting showing numbers in blue.
The column keeping the x-values must not be tagged as label range. "First column has has labels" = OFF.

[edge333]

The problem I outlined above persisted but in a different way when I turned off the "first column as label" option. The difference was as follows:

The left end of my scatter plot was anchored at the correct value of 9 with a given minimum of zero and a maximum at 30. The original min and max were 8 and 26. So all my data points shifted to the right like they should have but as you follow the x axis from 9 to 30, each data point became progressively misaligned with the correct x-value. So I changed the maximum back down to 26 and it fixed the problem. The trouble is that I don't want my maximum at 26, but rather back at 30. Is there a way to make the data scale correctly from the right hand side like it scaled correctly from the left-hand side?

NOTE: The y axis data column was highlighted green when I hit ctrl-F8. I had another column off which this column was based using an equation that subtracted five from the original data. So I'm assuming the the green values indicate numbers from an equation rather than simple numerical values (blue). Do they still need to be blue values? Must I manually change all the data in my y-value column?

[edge333]

I think I figured out what the problem is actually. Villeroy, maybe you could check this out?

So I'm actually using the secondary x-axis instead of the primary one and I don't think you can change the secondary x-axis scale and have your data scale with it if your primary x-axis scale is still set on automatic.