Cannot scale dates in pivot chart

[carast]

I've created a pivot chart (from a pivot table) that graphs dates on th
x-axis vs. numeric values on the y-axis. The dates are not contiguou
in the source data. As a result, the pivot chart only displays th
dates in the source data and skews the graph. If I was to create
simple graph of dates vs. numbers and select the format axis, I hav
options of selecting the starting date, the ending date, the number o
days between ticks, etc. This data is not skewed. Is there a way t
get Excel to recognize that the x-axis data is a date and/or get it t
realize I'm dealing with a date range and format it accordingly

 

[Earl Kiosterud]

Carast,

Your simple chart probably had a time scale instead of a category scale for
the x axis. The Pivot Chart doesn't seem to allow that (It would be in
Chart Options, Axis). And if you try to make a chart manually from the
pivot table, you get the same restriction (it makes the chart instantly,
giving you no options to set anything up).

One possibility, though not elegant, is to put a range of all the dates you
expect to see, with the corresponding values zero or empty. This will force
a category for each date (which is what the time-scale x axis does anyway).
Include these bogus dates in your range of data to which the pivot chart
refers.

 

[Debra Dalgleish]

Or, double-click on the Date field button, and add a check mark to 'Show
items with no data'