Graph won't refresh

I have a graph that I've put together in Excel from a chart, and have spent a good time trying to get it exactly how I want it over the past several months. But, the data only went up to x date, and now I'm adding in more rows into my chart, they won't refresh in my graph.

I've tried "select data" in the FEED DATA sheet and then re-capturing all the data I want added in, but then it changes my whole graph in FEED GRAPH tab into different formats, which is a pain in the bum.
There doesn't seem to be a way of just dragging the data selected box down (i.e no cross hairs to do that). I think I had this problem before and had to start all over again which I really don't want to have to do. Anybody have any ideas?

Can't seem to add in pics!

Welcom tothe Forum.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

I have been known to select a data series, press F2 to edit the series, and then edit the "formula" to use the desired ranges. If this will change frequently, though, this approach gets tedious.

The easier approach will be to convert the table in Feed data to a structured table, then do a one time adjustment to make sure the chart in feed graph is using the entire table. The advantage of a structured table for this sort of thing is that it automatically extends as you add new rows to the data.

A third approach might be to use dynamic named ranges.

See this tutorial for a more detailed discussion: https://chandoo.org/wp/dynamic-chart-data-series/

Here it is with Dynamic Named Ranges

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Not to worry. Just get on with sharing the love. You must be as old as I am, or just into watching old Carry On films