Updating values without updating graphs

I have weekly data I update, and would prefer to not have to update the graph each week. Is this possible? I tried selecting more empty cells for the graph, hoping it wouldnt graph until data was present, but am having no luck.

Hi Nj8988,

Since you are using Excel 2010, I would recommend the technique that I demonstrate with a step-by-step tutorial as well as a video here:

How-to Make Dynamic Excel Dashboard Charts Using Tables


However, if you really want to make it complicated (but probably unnecessary based on your data), you can also use the offset method as you can also see in a step-by-step and video tutorial here:
Case Study - Creating a Dynamic Chart in Excel Using Offset Formula



Steve=True