Is there a different way of displaying the max value?
Hi everyone,
I'd like to build a chart that displays spend vs. total budget with the chart colour changing depending if the project is over/under budget, and the chart also displaying the max budget.
I used a really helpful tutorial to build the example chart below but wondered if there's a different way of detailing/displaying the max budget? I've also added a screenshot of my example table that the chart is built from.
Any help would be greatly appreciated.
Thanks,
Kristina
Best Answer
-
You could possibly go for something like this?
Budget forms part of the project name so everyone can see what they are working to, you cant auto change series color, but if you separate it out you can only display it in the event it happens?
Stacked graphs would be far better but the displayed values overwrite each other (its a known smartsheet development issue) so the above are currently the only ways I can think you could do what you need automatically?
Here is the updated data table
formula in overspend column
=IF(Spend@row > [Total Budget]@row, Spend@row - [Total Budget]@row, "")
formula in spend in budget column
=IF(ISBLANK(Overspend@row), Spend@row, [Total Budget]@row)
Hope it helps
Thanks
Paul
Answers
-
You could possibly go for something like this?
Budget forms part of the project name so everyone can see what they are working to, you cant auto change series color, but if you separate it out you can only display it in the event it happens?
Stacked graphs would be far better but the displayed values overwrite each other (its a known smartsheet development issue) so the above are currently the only ways I can think you could do what you need automatically?
Here is the updated data table
formula in overspend column
=IF(Spend@row > [Total Budget]@row, Spend@row - [Total Budget]@row, "")
formula in spend in budget column
=IF(ISBLANK(Overspend@row), Spend@row, [Total Budget]@row)
Hope it helps
Thanks
Paul
-
Thanks Paul! That's really helpful
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!