Hey guys,
I have a spreadsheet, and on one of these sheets I have approximately 11,000 records. At this point, I have created a pivot table based on this data. As I want to see some trends over time, and one of these columns is a date value, I have created a pivot table where I have 2 row labels and 1 column label.
From this table, I have now created a stacked column graph. It looks great, but I am hoping to tweak its formatting just a tad. At the moment, each column is spaced an equal distance apart. I am able to change the gap percentage for a series, and the gap between all columns is removed. This is half of what I want to do.
I am wishing to reduce the gap between the columns for the 1st row label, but keep a small gap between the groups of columns for the second row. I hope that makes sense.
How would I go about doing this in Excel? May am is to do this programmatically, but once I figure out how to do it manually, I can record a macro and go from there.
Thanks alot for your help!
Bookmarks