charting pivot table results by month

  • Thread starter Thread starter Talos1143
  • Start date Start date
T

Talos1143

I am trying to create a chart that shows monthly totals from pivot table
results. Each record has a date in the first field in the format, 01/01/2004.
I have been using the Month function on the date field to change it to a number
corresponding to the month before creating the pivot chart. This gives me the
monthly totals that I need but I think there must be an easier way. Any
suggestions?

Thanks.
Ken
 
Ken -

If you use a custom number format of m or mm, your date will appear as
just the month's number, 2 or 02 for February. mmm would give you Feb,
and mmmm February. This wouldn't change the underlying date value of the
cell or label.

- Jon
 
Back
Top