Charts - Using first row as a target
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
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives