# How to Remove Chart Category

#### Tech56

##### Member
Hello,

On my Report sheet I put a large red arrow showing a #REF that I would like to be removed please. I recently deleted that category and no longer need on the chart but don't know how to do this.

#### Attachments

• 722.5 KB Views: 5

#### vletm

##### Excel Ninja
Tech56
You should do something to cell F16!

#### Tech56

##### Member
Ah I see that now thank you very much for help.

#### Chihiro

##### Excel Ninja
Hmm, personally I'd recommend setting up calculations, rather than direct link to cells.

Ex:
B9 =SUMIF(\$A\$28:\$A\$123,"Total *",B28:B123)
Copy across

F8 =IFERROR(INDEX(\$A\$28:\$A\$123,AGGREGATE(15,6,(ROW(\$28:\$123)-27)/(\$B\$28:\$B\$123="Budget"),ROWS(\$A\$1:A1))),"")
Copy Down.

G8 =IFERROR(INDEX(B\$28:B\$123,MATCH("Total " &\$F8,\$A\$28:\$A\$123,0)),"")
Copy down and across.

Etc.

Additionally you can set up each of source ranges/rows as dynamic named range to accommodate for more items being added.

As well, chart series can also be made dynamic.

#### Tech56

##### Member
Thank you Chihiro for the excellent formulas which I have implemented.

Also thank you vletm for pointing out where the #REF was the issue. I am learning a great deal so far from this forum!