(Msg. 1) Posted: Wed Aug 06, 2008 5:14 pm
Post subject: Piviot Chart - format x axis Add to elertz Archived from groups: microsoft>public>excel>charting (more info?)
Hello everyone
I know this must be easy but I am having a brain freeze and just can't seem
to think of how to do this.
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 gone into the format area
for the x-axis and chosen number then date and the "Jul-08" as the format but
it doesn't change the format on the chart. It still shows as 7/31/08. Is
there some type of protection perhaps that I need to turn off? HELP I really
need it to be Jul-08
--
Cher
(Msg. 2) Posted: Sat Aug 09, 2008 1:38 pm
Post subject: Re: Piviot Chart - format x axis Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The pivot chart number formats are controlled by the field format in the
pivot table.
Right-click a date in the pivot table
Click on Field Settings
Change the Number Format to the date format that you want.
Cher062 wrote:
> Hello everyone
>
> I know this must be easy but I am having a brain freeze and just can't seem
> to think of how to do this.
>
> 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 gone into the format area
> for the x-axis and chosen number then date and the "Jul-08" as the format but
> it doesn't change the format on the chart. It still shows as 7/31/08. Is
> there some type of protection perhaps that I need to turn off? HELP I really
> need it to be Jul-08
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office