| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category Axis Date Labels
I have a large workbook with several worksheets. I am using multiple
consolidation ranges to pull data into a pivot table and chart. On the data worksheets, my date format is mmm-yy, when I run the consolidation, the X-axis (category) displays mm/dd/yyyy in all numbers (03/01/2001) when I really want to see MAR-01 for March of 2001 -- Thanks for your help, QAFB |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Category Axis Date Labels
I figured it out with some work and deduction: I moved all the data as values
into a single worksheet and created a chart, thus skipping the pivot and equations. Then I selected "Format Axis" on the category axis and selected the number tab and custom then mmm-yy, and viola! Thanks Me, ,,Quidam -- Thanks for your help, QAFB "Quidam2" wrote: I have a large workbook with several worksheets. I am using multiple consolidation ranges to pull data into a pivot table and chart. On the data worksheets, my date format is mmm-yy, when I run the consolidation, the X-axis (category) displays mm/dd/yyyy in all numbers (03/01/2001) when I really want to see MAR-01 for March of 2001 -- Thanks for your help, QAFB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing Axis Category Labels | Charts and Charting in Excel | |||
| Appearance two labels on category axis | Charts and Charting in Excel | |||
| Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
| alignment of y axis category labels | Charts and Charting in Excel | |||
| Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Hybrid Mode
