The attached spreadsheet has me tearing what little hair I have left out! I am trying to get it to auto update the charts based on the tables in the first tab.
The issue is that I have to remove the oldest month and add the previous. When I do this I then have to go to the chart and change the "Select Data" to point it at the added line.
I also need the charts to auto format based on the conditions of whether the target is above or below the actual. I also need the Max one to format based on the figure of the previous month, Red if it is higher, Green if lower. At present I am doing these formatting changes manually but there must be an easier way!
Any help would be gratefully received!
Regards
Stephen
Bookmarks