• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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.

Thank you for your help
 

Attachments

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!

:DD
 
Top