I have a set of data that shows a total budget of the project (column A). Let's assume in $1000. I have another source data that shows me actual spend to date, e.g. $600 (column B). Is there a way to show the data bar on column A and reflect the 60% spend. In other words, I would like to cell with $1000 to show a bar across it at 60%.
I hope that's clear.
Thanks in advance.
Bookmarks