PivotChart - Formating a Date for an Axis

T

Tom

No matter how I format a Date in the pivot table, the date
stays in the format mm/dd/yyyy on the chart. Any clues?

TIA
 
J

Jon Peltier

Tom -

This is another example of the restricted formattability of pivot charts
compared to regular charts. You could just make a regular chart form the
data, or enter your dates as text in the original data list. Both of
these are likely to have drawbacks.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top