Set Graph to Auto-Update After Applying Values

Originally Posted by Andy Pope

On this site.
https://www.google.co.uk/search?hl=e...pe=&as_rights=


http://peltiertech.com/Excel/Charts/Dynamics.html

Thanks i found what i need to do earlier but i cant seem to make it right with my graph. Tried the "Tables" way, I select the range of dates on Column A, but my graph would still extend to the 0 values.

Using the Offset Formula doesn't affect my current graphs. Do I need to create new sheets all over again? Should i reupload my excel sheet?