show missing values in pivot chart (line chart) axis

[danjosef]

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart. Any suggestions or workarounds?

 

[danjosef]

Alternatively - is what I'm trying to do impossible?

 

[AllyOops]

I have the same question nearly three years later!

 

[AllyOops]

I think I will go and add a number of Fake Records to tidy up the axis!