How can I add a trend line in a bar graph?
I have recently started using Smartsheet and have been on YouTube and this amazing forum to self teach. I have a couple of questions which I hope I can get answers for
- I have bar chart made with 6 bars. Am I able to add a trend line into this? I would ideally like to represent where we should be as opposed to where we currently sit.
- I also have a line graph, with several bits of data in it, there are 8 lines in total, however I have to click on the legends individually to eliminate them from the graph itself. Is there an easier way instead of clicking 7/8 legends just to see 1 line? Ideally I would like to click on the legends I would like to see rather than rule them out.
Looking forward to the response and thank you all!