Excel pivot chart - Scales on multiple field buttons

A

Ali

Hi

I hope someone can suggest a solution or workaround to the following...



I have created a pivot chart with dates along the x-axis. As I have a
wide time period I have changed the scale to show every 10 dates only.
To help make it clearer we would also like to show the month on the
x-axis below the date. I have added this to the data source and when I

drag this down to the x-axis as well it reformats the spacing between
the dates so that it turns into a big black mess of dates again. Is
there a way to respecify the scale of the date field as when I click on

the format axis/scale menues the category boxes are greyed out?


Any ideas would be much appreciated.
 

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

Similar Threads

Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
change x axis date scale on multiple charts quarterly 0
Formatting 'X' Axis -- 2 fundamental differences 7
Additional secondary axis scales 0
Log scale and minor gridline labels 2
Line Chart - Problems with labeling X-Axis 3
Formatting pivot chart axis labels for dates 10
multi dimension/axis single series bar chart 0

Top