Excel 2007 : Pivot Line Chart Linear X-Axis

Hey,

I am trying to crunch some data with Excel 2007.

Problem: I cannot make the X-Axis on a Pivot Line Chart use a linear scale

Data collection:
Data was recorded by increasing the steps and measuring the X-Axis data and the Y-Axis data. After all the data was collected it is best to analyze it with the Axis as mentioned.

Pivot Table:
I used a pivot table as there are other columns of data obtained, it is is very easy to switch what data you are looking at.

Pivot Line Chart:
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?

Thanks!

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.