| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format the x axis of a pivot chart, no number tab???
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't see the number tab when formatting the X axis on a Pivot cha | Charts and Charting in Excel | |||
| Pivot Chart Y Axis | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| How to sort x-axis in pivot chart | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Threaded Mode
