Hack ...
That's a very valuable tip! No it doesn't apply in my case ... but I will definitely put it in my reference Cookbook!
I have a static area for my chart, but the data has to change based on other data that gets entered on the sheet. I wanted my calculated data block updated with the newly entered data in my series. Sometime, I may need to combine BOTH approaches!
Thanks again!




Reply With Quote