Hello,
I have a graph that I need help with. Along the horizontal axis I have times of the day which is group by the date itself. I would like to expand the grouping up into the plot area. Not easy to explain so please find attached a test sheet.
The first graph is how it currently is, I have added purple boxes to highlight the data grouping.
The second graph is how I would like it to be, I have added red lines to highlight.
I am using MS Excel 2010
Can this be done.?
Thank you.
The axis setting of Interval between tickmarks of 4 would normally reduce the number of vertical gridlines.
But this value is ignored when Multilevel labels are applied.
So you need to make use of the secondary horizontal axis in order to apply gridlines.
Use a dummy series which is moved to secondary axis.
Add secondary horizontal axis and set interval between tickmarks.
You can then format both secondary axes so the labels are not displayed.
Finally delete dummy legend entry
Thank you Andy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks