Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are Pivot Charts only useful with limited number of categories(x-axis)? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Pivot Chart - Formatting Axis on Data Table | Charts and Charting in Excel | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |