How do I plot the x-axis in a PivotChart as an Axis Field? I have my x y values but the only way to get the x-axis to plot correctly is to put it into the Value Field and I do not want a calculation on the x-axis (Count, Sum, etc). I just need the value.