How can I scale a line graph to actually show the trend?

gbrown
gbrown Member
in Cards, Dashboards, Stories

Hello I have a line graph of actual # and the full year tracker of our target/stretch goal. This is a sum of all 3 areas and can filter to only show an areas progress. How can I use the scaling to actually show the tend line? Currently it is just a thin narrow straight line that does not show any progress?

image.png

Thanks,

Garrett

Tagged:

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    edited February 3 Answer ✓

    I can't tell from you've written if your problem is A) the graph goes to 12/2025, even though you only have data through 1/2025. B) It's hard to see the "action", because the y-axis goes from 0 to 40M, even though the values are all in the 25M to 35M range.

    If it's A, then you need to filter. You could filter for Actual RM > -1, or play with the date range to only show past dates, not dates in the future.

    If it's B, then I would start with adjusting the value scale (y) to not include 0. I like that option, because the graph will still scale the axes with the data if the range changes. If that's not enough, then you can set the min/max to something like 25M to 35M to really focus on where your data is.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    edited February 3 Answer ✓

    I can't tell from you've written if your problem is A) the graph goes to 12/2025, even though you only have data through 1/2025. B) It's hard to see the "action", because the y-axis goes from 0 to 40M, even though the values are all in the 25M to 35M range.

    If it's A, then you need to filter. You could filter for Actual RM > -1, or play with the date range to only show past dates, not dates in the future.

    If it's B, then I would start with adjusting the value scale (y) to not include 0. I like that option, because the graph will still scale the axes with the data if the range changes. If that's not enough, then you can set the min/max to something like 25M to 35M to really focus on where your data is.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories