Set Graph to Auto-Update After Applying Values

**yakabod** · 10-09-2013, 01:34 PM

As seen on the attachment i provided, how can the graph be automatically updated when values are applied? I can set the range of rows but then graph will have empty data on the dates.

FY14 OB DQC tracker.xls

**Andy Pope** · 10-10-2013, 05:04 AM

you can use named ranges to control the data range used for a data series.

There are many examples on the forum

**yakabod** · 10-30-2013, 12:06 PM

I can't find any examples or directions to accomplish my goal.

**Andy Pope** · 10-30-2013, 12:16 PM

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

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

**yakabod** · 10-30-2013, 01:25 PM

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?

**yakabod** · 10-30-2013, 01:50 PM

So i set the tables for my Actual Data and then the Date. So I leave the ranges for I5 to I25 and then A5 to A25, but then i add the new value to I26 = 100 and the graph didnt update?

10-30-2013 10-48-24 AM.jpg 10-30-2013 10-45-41 AM.jpg

**yakabod** · 10-30-2013, 01:52 PM

Then i tried to extend the ranges to I56 and it just makes the graph look ugly.

1.jpg 2.jpg

**Andy Pope** · 10-31-2013, 04:39 AM

Yes post workbook example.

**Andy Pope** · 10-31-2013, 04:49 AM

Actually you existing file will do.

I have added 3 named ranges for Data, Labels and Goal.

Give the condensed nature of your data I used Line chart for both rather than column/line combination.