How to mimic Log scale graph in Smartsheet?

Kevin7859

I am trying to create a graph for a dashboard where the # of projects is one bar and the total cost is a secondary bar. But the 3 of project is so much less it only shows as a number and no bar associated with the value. In Excel I can perform a Log scale to show the bar for the Total projects, any ideas for mimicking this function but keeping the values the same values displayed?

Matt Lynn#

@Kevin7859 You may not want to do this but just an idea that I've done before is to divide the millions by a value that would get it closer to the number of the other (Example: $105,194,098 / 1,000,000 = 105) and make the legend say "Total Costs (M)" or something to indicate that the 105 is $105m. Of course then your 2066 would be bigger.

Outside of some kind of data manipulation I don't think there's a way to scale it or incorrectly scale it and keep the values as they are.

Matt Lynn#

@Kevin7859 You may not want to do this but just an idea that I've done before is to divide the millions by a value that would get it closer to the number of the other (Example: $105,194,098 / 1,000,000 = 105) and make the legend say "Total Costs (M)" or something to indicate that the 105 is $105m. Of course then your 2066 would be bigger.

Outside of some kind of data manipulation I don't think there's a way to scale it or incorrectly scale it and keep the values as they are.

Humashankar

Great Explanation