Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!!!!! |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combing Pivot and Non-Pivot datasets for 2-axis charts. | Charts and Charting in Excel | |||
Pivot Charts | Charts and Charting in Excel | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel |