Excel 2007 : Pivot Line Chart Linear X-Axis

Originally Posted by MrShorty

I never use Pivot Tables, so I don't know if that effects this suggestion, but it sounds to me like you want a scatter plot rather than a line chart. See if converting your line chart to a scatter plot gives you the result you want.

Pivot Tables/Charts do not allow you to use Scatter Plots

The fundamental problem is the x-axis values are being treated as categorical variables instead of numeric. Categorical meaning each value you record is one tick/category on the x-axis.