In Excel, How can I make the graph change by adding or taking away data? When I do, it doesn't update graph?

Question

I added future weeks into my data. However, my boss doesn't want it that way...he says it looks like we are low in production. So, each week I have to do a WHOLE NEW graph for the new week. Isn't there an easier way? Because when I subtract the weeks I don't want from the data, it doesn't update the graphs, and on the graphs, it won't allow me to just delete the weeks.

I use both kind of graphs with one data....I use a line graph and I also use a bar graph. Thanks

Answer 1

This solution autoupdate the chart as you enter the data in the table, since you didn't mention the details of the columns, i made up a 3 columns table for the automation

Here's the solution to your problem

http://www.freewebs.com/swhtam/YA/autoUp...

Inside the file there will be notes on the solution,

Please contact for more info