Charts - Using first row as a target

WillH ✭✭✭
edited 05/07/24 in Smartsheet Basics

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!



  • Jgorsich
    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.