comparison chart

I notice a couple of items. For one, the there are two series called Operational Hours. Actually, you have this value plotted twice. What you don't have plotted is Effective hours.

Also all the averages are the same color so you can't tell which is which unless you hover over them on the chart.

Also you added Non Productive HRs to the legend manually, but it's not plotted.

Attached is my suggestion. I plotted the non-productive hours and temporarily assigned one of the entries a value so I could select the series and change the fill to red. I then set it back to zero. This makes it show up on the legend and it will be plotted should it get a value.

I changed the averages from bars to lines. I matched the colors of the bars to the lines for example Usage hours and Usage hour average are both orange. The bars are a slightly lighter color than the lines and I put in a fill pattern so you can still see them, but they are also distinguishable from the same color line.

My only regret is that the lines start and end over the SN labels. I wish they went from the leftmost column to the rightmost column. I might be able to do some "cheating" with helper cells and secondary axis. Also I would have preferred if the legend came out in order. That is Effective Hours, Average Effective Hours, Operational Hours, Average Operational Hours, etc. Apparently Excel puts them in chart type order.

I think this is the best we can do for now.

I just did another experiment. I think the chart looks a bit cleaner with the lines without the markers. I also noticed that I did not put the data labels back in.

And here's a version: No lines and markers only.

I just figured out why the bars are off center - they actually aren't. The unproductive hours are at zero.

I can't figure out a way with the way you have the data formatted.

Jon Peltier likes to use a "dummy series" and label it to locate the axis labels in a clustered and stacked column chart: http://peltiertech.com/clustered-sta...mn-bar-charts/