Excel Charts not updating

GeorgeBryant

New Member
Joined
Sep 25, 2013
Messages
10
I have found a lot of questions online to this problem and wondering if someone here has a solution.

I have a workbook with about 20 different line and bar charts. The data is fed by one master table of table (contains EVERYTHING) and then another smaller table that pulls from the master table through a series of lookups based on the users selection. The Lookups are working fine (all rows of data are populating correctly - so I know that it isn't a setting of 'manual' vs. 'automatic' udating) but for some reason the charts are not all updating correctly. For example, I have one line chart with 7 lines that pulls from 7 rows of data and 5 of the lines are updating but the other two do not. If I cut and paste the chart, all 6 lines are correct but then I get the same problem the next time I run a new LookUp.
We rely on the graphics on this page for a dashboard so we need to ensure the data is updated based on the user selection (no easy way to tell if the data didn't update unless you check the data table against the chart each time) I prefer not to create a macro if possible since this adds another complication when we update the workbook each month.

Any solutions out there?
 

Attachments

  • Excel graph update.png
    Excel graph update.png
    132.3 KB · Views: 1

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,118,358
Messages
5,571,710
Members
412,414
Latest member
KasunC
Top