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
|
|||
|
|||
Date display in Pivot Chart
I have a piviot chart and the x-axis has dates. It is currently displayed
as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field Settings" in the pivot table but the dates still show as 7/31/08 in the chart. HELP!! I'm pulling my hair out!! |
#2
|
|||
|
|||
Date display in Pivot Chart
Hi,
Since you didn't tell us what version of Excel, lets assume 2003 - In the pivot chart right-click on the field button for the Date field, choose Format Pivot Chart Field, click Number, and either use one of the built-in date formats or choose Custom and enter your own. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Erin" wrote: I have a piviot chart and the x-axis has dates. It is currently displayed as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field Settings" in the pivot table but the dates still show as 7/31/08 in the chart. HELP!! I'm pulling my hair out!! |
#3
|
|||
|
|||
Date display in Pivot Chart
Yes, I'm using 2003. When I right click and go to "field settings" I don't
get an option to choose anything but these: SUM, Count, AVG, MAX etc. I've changed the cel format to be MON-YY too. Any other ideas? "Shane Devenshire" wrote: Hi, Since you didn't tell us what version of Excel, lets assume 2003 - In the pivot chart right-click on the field button for the Date field, choose Format Pivot Chart Field, click Number, and either use one of the built-in date formats or choose Custom and enter your own. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Erin" wrote: I have a piviot chart and the x-axis has dates. It is currently displayed as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field Settings" in the pivot table but the dates still show as 7/31/08 in the chart. HELP!! I'm pulling my hair out!! |
Thread Tools | |
Display Modes | |
|
|