Hi all.
I have a smiley chart I found that uses a macro, but I cannot get it to work as I want it to.
If I input the total manually it works, but I want it to work from a cell that contains a formula. I have attached the sheet for you to have a look at. The idea is that I input amounts each month, the total at the bottom adds the values up and plots the chart.
Any ideas would be appreciated.
Thanks,
Tony
Bookmarks