Can't see the number tab when formatting the X axis on a Pivot cha
My x axis has dates like 08/31/07. I want to change the formatting to
Aug-07. For some reason when I format the X axis I can't see the "Number" tab. I can see it fine for the Y axis or when I format the X axis on a regular chart, but not the X axis on a pivot chart. I also tried changing the formatting on the source data and the source pivot table. Nothing works for the pivot chart except changing the source data to text which I don't want to do because I need them in number format for other calculations. Please help. |
Can't see the number tab when formatting the X axis on a Pivot cha
have you set the cell format?
right-click cellnumber tabcategory:custom -- Regards, Linda "Aaron" wrote: My x axis has dates like 08/31/07. I want to change the formatting to Aug-07. For some reason when I format the X axis I can't see the "Number" tab. I can see it fine for the Y axis or when I format the X axis on a regular chart, but not the X axis on a pivot chart. I also tried changing the formatting on the source data and the source pivot table. Nothing works for the pivot chart except changing the source data to text which I don't want to do because I need them in number format for other calculations. Please help. |
Can't see the number tab when formatting the X axis on a Pivot
Not sure I understand you? As noted in my original question I tried
formatting the cells in the source data and the cells in the pivot table. But the chart is not looking at the formating, it is looking at the value. It seems that the catagory axis can't be formated by number, the whole tab is gone. Not sure where I'm going wrong here. "linda" wrote: have you set the cell format? right-click cellnumber tabcategory:custom -- Regards, Linda "Aaron" wrote: My x axis has dates like 08/31/07. I want to change the formatting to Aug-07. For some reason when I format the X axis I can't see the "Number" tab. I can see it fine for the Y axis or when I format the X axis on a regular chart, but not the X axis on a pivot chart. I also tried changing the formatting on the source data and the source pivot table. Nothing works for the pivot chart except changing the source data to text which I don't want to do because I need them in number format for other calculations. Please help. |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com