close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄