If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Chart Data Table
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? |
#2
|
|||
|
|||
Pivot Chart Data Table
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? |
Thread Tools | |
Display Modes | |
|
|