Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the category axis number formatting in a Pivot Ch.
I have created a Pivot Chart from Excel data (Excel 2000) and I need to
figure out how to change the category axis number formatting. Currently, the dates in the chart are showing up in long form (01/01/2005) and I would like to change this to something shorter like 1/01. I changed the formatting of the data in the original raw data and then in the Pivot Table, but neither of these seemed to change the Pivot Chart formatting. When I right click on the category axis, I do not get the option the change the number formatting (I do for the value axis however). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the value axis scale | Charts and Charting in Excel | |||
How do I change z-axis value from zero to a higher number (eg 4)? | Charts and Charting in Excel | |||
how do i change data on the x or y axis... | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel |