Prev: Secondary Row Group not displaying second value
Next: Change All Data Labels in Excel 2007 Stacked Bar Chart
From: Lizz45ie on 29 Jan 2010 16:25
Hello,
I created a pviot chart - the months are not formatted correctly. The
months are formatted correctly in the raw data and in the pivot table. How
can I can the format the month in the data table to month-year instead of
mm/dd/yy?
From: trip_to_tokyo on 30 Jan 2010 06:38
Hi Lizz, I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 52 towards the top of my home page.

In this you should find that the underlying data, the Pivot Table and the
Pivot Chart are all formatted as mmm-yy as you require.

This file was made in EXCEL 2007.

All I did was formatted the underlying data as Custom (see Workbook) and
everything else after that (the Pivot Table and the Pivot Chart) followed
through without any further intervention by me.

Please hit Yes if my comments have helped.

Thanks.




"Lizz45ie" wrote:

> Hello,
> I created a pviot chart - the months are not formatted correctly. The
> months are formatted correctly in the raw data and in the pivot table. How
> can I can the format the month in the data table to month-year instead of
> mm/dd/yy?
 | 
Pages: 1
Prev: Secondary Row Group not displaying second value
Next: Change All Data Labels in Excel 2007 Stacked Bar Chart