That named range contains an offset formula to make the graph dynamically add more data points as they are entered.My named range is Param1_200 and it is defined as: =OFFSET(Data Entry! $J9:$J8),1) For some reason new data points are not getting added to the graph as they are entered.
Instead of waiting impatiently while it recalculates after every change you make, you can set the recalculation to manual, make all of your changes, and then recalculate at once.
If Sheet1 Column A = nothing(blank) And Column B = \\\CC\\\ Then Sheet 2 B7 = Sum Total.
As a regular formula would be nice or VB code Hi Richard you want nothing at all in the whole of column A in sheet 1?
Now data points don't get put on graph and when I go to sheet containing graph I get error message: "A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook range name, and cell reference." Any ideas how I can get graph to add new data points and get rid of error message?