Excel 2007 : Pivot Line Chart Linear X-Axis

Both the X-Axis and Y-Axis data is continuous. When using a line chart I cannot make the X-Axis plot on a linear scale. It can only plot each discrete point. I like using the Pivot Table/Chart as it is a very efficient way to analyze data form multiple iterations.

Is it possible to make the X-Axis on a line chart use a linear scale?

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.

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.