Column Graph - Series Overlap 100% - Is it possible to see both of the columns?

[Mark McInerney]

Hi All,

I have a column graph, and I format the data series to have 100% overlap below - is there there a way to see both columns ( I cannot see where the green columns end in data points 2 thru 8)

 

[RoryA]

I usually use a semi-transparent fill on the series that's in front. If it's something like budget vs actual, I might also give the budget no fill and a thick border so it looks like it's being 'filled' and can be seen around the edge of the actual.

 

[Mark McInerney]

Hi - Should have been able to figure this one out!! Thank you very much for taking the time to review this. Best - Mark.

 

[RoryA]

Glad to help.