Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
16
Views
Topic starter
Hello,
I have a workbook with a graph that I update weekly. I am trying to get the weekly DPMO to update only to the current week. The current view is showing 10/23 with 0 DPMO. That should not be showing, since I won't update this info until next week.
Posted : 25/10/2023 7:19 am
You can define a named range, WeeklyDPMO as:
=Sheet1!$J$9:INDEX(Sheet1!$J$9:$J$13,COUNT(Sheet1!$J$9:$J$13))
(adjust to match your real workbook ranges), then use that as the source data for your chart series. COUNT ignores error values, so your #DIV/0 errors won't be included.
Posted : 28/10/2023 10:55 am
Topic starter
Thank you, Velouria. That worked! Much appreciated.
Posted : 07/11/2023 3:45 pm
Just playing around with the cell contents, I don't like DIV/0 and NA in tables
Posted : 08/11/2023 3:17 am
