Stacked bar chart that only goes to 100%



I'm trying to create a stacked bar chart that combines the Actual number, the Deal Model Number, and the projected number into one line. I'd like the bar chart to only go to 100% and as the Actual number goes higher, it shows it creeping up the bar towards the deal model / projected number. I'm not even sure what kind of formula I would use for this. I have the three numbers in a separate sheet that are to be updated manually by another department, so there are no dependencies on them. Thoughts?

Thank you!



  • Leibel S
    Leibel S ✭✭✭✭✭✭

    @Emily T.

    In a sheet being in each of the numbers into their own column.

    then you make a column for each of them (which is the value you want for the chart). These would be a formula that is: the value / the total value

    Not sure this explains it in full, but try building on it...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!