• 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

  • Money Manager 10.1.xlsm
    722.5 KB · Views: 5
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.
 
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
 
Back
Top