LinkBack URL
About LinkBacks
Hi,
In a pie chart, I am looking for a way to hide the legend if a cell value is blank.
I want to build the pie chart dynamically so column D is using =Unique from Column A.
Screenshot 2024-08-01 110445.png
Hi,
In a pie chart, I am looking for a way to hide the legend if a cell value is blank.
I want to build the pie chart dynamically so column D is using =Unique from Column A.
Screenshot 2024-08-01 110445.png
Traditional way would be to create 2 Names in workbook (Formulas->Defined Names->Define Name) or directly calling Name Manager (Ctrl+F3) such as:
Formula:
Payer_Amounts =FILTER(Sheet1!$E$2:$E$49,Sheet1!$D$2:$D$49<>"")
Payer_Names =FILTER(Sheet1!$D$2:$D$49,Sheet1!$D$2:$D$49<>"")
and then use them for Series Values and Horizontal Axis Labels (write as Sheet1!Payer_Amounts and Sheet1!Payer_Names resp. - see screenshot)
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks