Mikeymike_W
Board Regular
- Joined
- Feb 25, 2016
- Messages
- 171
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
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