AnonymousX
New Member
- Joined
- Mar 3, 2017
- Messages
- 3
Hello,
I have a pivot table that has values for every hour through the year. I have my pivot table set up so that the horizontal axis splits every hour up for each month. ie you would see
| 0 2 4 6 8 10 12 14 16 18 20 22 | 0 2 4 6 8 10 12 14 16 18 20 22 | .....
| 1 | 2 |......
my question is that the hours get very cramped and are hard to see. I'd like to change them to display every 4 hours, however I do not see the option to do this in the "Format Axis" window. There is a field in the category of "Tick Marks" called "Interval between marks", I thought this would be what needs to be changed but it appears to do nothing.
If someone could explain how to change the hours intervals but leave the monthly ones alone that would be fantastic.
Using Excel 2013
I have a pivot table that has values for every hour through the year. I have my pivot table set up so that the horizontal axis splits every hour up for each month. ie you would see
| 0 2 4 6 8 10 12 14 16 18 20 22 | 0 2 4 6 8 10 12 14 16 18 20 22 | .....
| 1 | 2 |......
my question is that the hours get very cramped and are hard to see. I'd like to change them to display every 4 hours, however I do not see the option to do this in the "Format Axis" window. There is a field in the category of "Tick Marks" called "Interval between marks", I thought this would be what needs to be changed but it appears to do nothing.
If someone could explain how to change the hours intervals but leave the monthly ones alone that would be fantastic.
Using Excel 2013