Pivot Charts
 

Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!
--
Cher

Pivot Charts
 

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:
Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Pivot Charts
 

THANK YOU THANK YOU THANK YOU!!!

I knew there was a way but I just couldn't remember how to get to it. I
can't thank you enough.
--
Cher


"Debra Dalgleish" wrote:

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:
Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Pivot Charts
 

I have had this same problem. In some of my pivot tables, there is NO
NUMBER format button under field settings.

Why would this happen?



On 8/9/08 10:38 AM, in article , "Debra
Dalgleish" wrote:

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:
Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!

Pivot Charts
 

If the field has blank cells or cells with text, you might not be able
to format the numbers, because that field is treated as Text data type.

Greg McCarter wrote:
I have had this same problem. In some of my pivot tables, there is NO
NUMBER format button under field settings.

Why would this happen?



On 8/9/08 10:38 AM, in article , "Debra
Dalgleish" wrote:


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:

Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Pivot Charts
 

Aha, that explains what is going on. I have some conditional IF s in there
that set the value to "" if other cells are blank. I think I can fix by
replacing "" with 0.

Thanks!!


On 8/18/08 2:45 PM, in article , "Debra
Dalgleish" wrote:

If the field has blank cells or cells with text, you might not be able
to format the numbers, because that field is treated as Text data type.

Greg McCarter wrote:
I have had this same problem. In some of my pivot tables, there is NO
NUMBER format button under field settings.

Why would this happen?



On 8/9/08 10:38 AM, in article , "Debra
Dalgleish" wrote:


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:

Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change
on
the Pivot chart. it still shows as 7/31/08. How can I change this I
think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!