Create graph to show actual spend versus projected spend towards 100% complete

I have the information above and want to show a graph that indicates the health of the spend in a different colour in the same bar.

My graph if I select the two neighbouring cells (in my case actual vs projected) then the vertical axis sums the values of the two cells and the bar column now shows an ever increasing bar height, rather than one value growing towards 100% complete

is it possible




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!