Charts - Using first row as a target

WillH

Hello everyone,

I am hoping someone could help me with a chart that I am trying to create. The chart shows number of hours by 4 categories per week, with the top row being last years average. I would like the chart to show last years average as a straight line across the chart along with the weekly values fluctuating.

Example of report running the graph:

And example of the chart without the target line:

I am sure I could do this with helper columns by copying the target to a separate column and using column formula to copy the figure down to get the straight line. Is there an easier way to add the target line?

Thanks in advance!

Will

Jgorsich

That would be how I'd do it, and then manually color code each one to be a desaturated version of the primary color it applies too…

I'd also probably intersperse them with your actual data columns so that your legend reads a bit more logically then if you just put them all at the end.