I have a simple data set that I'm using to make a chart:
pic1.png
The chart is laid out how I want it to be, which I'm happy about, but I want to close this gap:
pic2.png
This will place the "Open" and "Closed" columns closer together leaving a larger gap between the Month series. Struggling to achieve this without affecting all columns.
Any help appreciated!
The way I have usually seen this done is to add a row (or two) where you want the larger gaps to be. Try inserting a row above "Feb", a row above "Mar", and a row above "Apr" and see what you think.
Originally Posted by shg
Thank you, the issue this raises is that the blank row gets grouped with "open" and "closed", so each month ends up with 3 columns that are offset because of the blank data. Not quite right unfortunately.
pic3.png
I think you'd need blank rows each side of the data sets, so there are effectively 4 categories for each month, with a blank each side.
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks