Hello to all.
in the attached chart I inserted in define name this formule:
I don't understand where I'm wrong, the chart doesn't updatePlease Login or Register to view this content.
adding or removing values
xam
Hello to all.
in the attached chart I inserted in define name this formule:
I don't understand where I'm wrong, the chart doesn't updatePlease Login or Register to view this content.
adding or removing values
xam
Maybe it doesn't work because in column F9:F28 there are formulas
which excel sees as non-empty cells?Please Login or Register to view this content.
I changed the reference to the chart from column F to column G now works.
An error:
if I delete the whole range A9:F9 error is displayed:
the formula of the work sheet contains one or more invalid references.
verify that the formulas contain valid references for paths, workbooks,range names and cells
how to fix the error?
xam
I believe that making the following changes to the defined name "Refers To:" formulas will eliminate the error message:
commessa:Formula:Please Login or Register to view this content.
percentuale:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi jetemac.
I tried your modifications but the error remains
xam
In the attached copy of the file both formulas are applied. Cells B9:F9 were deleted using the Delete key leaving B9:F9 blank. Then B9:F9 were deleted using the Delete Cells feature on the Home tab moving the values from B10:F20 up a row. Neither of those actions produced an error.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks