Results 1 to 2 of 2

Pie Chart - Hide legend if cell value is blank

Threaded View

  1. 08-01-2024, 05:06 AM #1
    varbergt
    varbergt is offline
    Registered User
    Join Date
    12-22-2023
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    60

    Pie Chart - Hide legend if cell value is blank

    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hide blank series labels from legend in check box chart
    By AkStassel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2020, 11:08 PM
  2. Hide legend items in a line graph when associated value = blank
    By fpunzi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2020, 11:48 PM
  3. VBA to remove legend with a blank cell from a chart
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2018, 04:05 AM
  4. [SOLVED] Hide legend items in a graph when associated value = zero or blank
    By bdicarlo1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-07-2018, 06:44 AM
  5. Hide legend items in a Stack Column chart when associated value is zero or blank
    By sahutika in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-10-2016, 03:15 PM
  6. Hide legend items in a LINE graph when associated value = zero or blank
    By juriemagic in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-11-2014, 10:06 AM
  7. How to hide a dummy series in a chart legend?
    By holg3r in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-14-2005, 04:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1