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

gbrown · 2025-01-31T19:49:21+00:00

There was an error rendering this rich post.

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?

Thanks,

Garrett

Find more posts tagged with

Cards

Graphs

Card Builder

Accepted answers

DavidChurchman

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.

All comments

DavidChurchman

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.