Pivot chart customise axis

[Mikeymike_W]

Hi All,

I have a pivot Table/Chart that is sorted into hours/days/months. I need it to be separated like this as I need to identify values that go over a certain level but the average would give a false value on the chart.

What I need to know is if it is possible for the horizontal axis to just show the month rather than the date, time and month?
Its just so messy and you cant even read what the axis says cause there's too much info trying to be shown.

So in summary the data is fine but the axis is not.

Many thanks,

Mike

 

[mole999]

you might try on your original data just adding a further value =datecell(text,"mmm") and using that in your pivot reference (you will need to expand the range and refresh to get it)