Share via

Set YTD Average Line on Mutiple Bar Graphs

Anonymous
2016-04-26T19:45:16+00:00

Hi,

I'm working with the below graph.  What I need to do is add a horizontal line across each bar starting in February that marks that color's moving YTD average.  So every month we can see which colors exceed the current YTD average and which do not.  So my data table has three extra columns not represented here... Blue YTD, Red YTD and Green YTD.  If I select any of those as lines on a combo graph, it draws three continuous lines up and down across all the colored bars, when what I want is just a simple horizontal line noting where within each bar is the current YTD average.

Does anyone know how to set this up?

What I want (through the magic of MS Paint):

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest