Pivot Line Chart - X axis label formating

**celine** · 12-04-2009, 05:09 AM

Dear all,

I would like to represent both month and daily data in line chart.
I am using pivot Line chart.
For normal chart i can able to show x axis label like
sep-09,oct-09,01-nov-09,02-nov-09,03-nov-09 like this.

But for pivot chart able to show one format only

either
01-sep-09,01-oct-09,01-nov-09,02-nov-09,03-nov-09
or
sep-09,oct-09,11/01/09,11/02/09,11/03/09

Is there any possibility of showing x axis lable like below
sep-09,oct-09,01-nov-09,02-nov-09,03-nov-09

I have attached screen shots for reference.

Thanks in advance

**Andy Pope** · 12-04-2009, 05:23 AM

The pivot chart takes the number format of the Field not the formatting of the individually rows.

To get the formatting you require you would need to make a standard chart based on the pivot table and set the axis to category. The the individual number formats can be displayed.