Pivot Chart & Text(A1,"Mmm YY")

[=?iso-8859-1?B?QWRhbSCsrA==?=]

Dear All,

I have a pivot chart that shows over the last 12 months
the number of units sold. The data it relates too has the
date the unit was sold i.e dd/mm/yy and the stock code
which it counts from.

So I made another field called Invoice Month which had
the formula =text(a2,"Mmm YY") and used that column as
the bottom axis of the pivot chart however when it
produces the graph the bottom axis is sorted in
alphabetical order and not date as wanted.

I want the the Bottom axis (x from memory) to line up
correctly as the format Mmm YY. So should start Jan 02,
Feb 02 and not go in Alphabetical order.

Any ideas please?

Adam

 

[Debra Dalgleish]

Instead of using a column in the source table, you can group the dates
in the Pivot Table.

1. Add the date to the row area of the pivot table
2. Right-click on the Date field button
3. Choose Group and Show Detail>Group
4. Select Years and Months, click OK