Scatter Graph: Plotting Value x Effort
Hi Smartsheet Community,
My organization has a few questions about scatter graphs. Our goal is to create a graph that charts the organization’s projects according to value and effort on the X and Y axis.
Here is an example of the format we want to create in PowerPoint. Of course, it would be much better in Smartsheet because it could be updated in real time.
Question 1: How do we chart Value x Effort in a Scatter Graph?
We have two columns of data. Value is out of 25 and Effort is out of 5. What would the settings be in the Scatter graph to plot the projects as the x and y axis on the graph? Is this possible in Smartsheet? So far we have only managed to plot them independently.
Question 2: How do we flip the axis so that Effort goes high to low?
One last ask is that effort starts at 5 on the axis and goes up to 0. This is possible in Excel. Not sure if this is possible in Smartsheet. How do we flip the axis so that Effort starts at 5 instead of 0?
Thanks very much for any help you can offer!