Charts in Excel- please help on making charts that ignore blank cells in a spreadsheet

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Charts in Excel- please help on making charts that ignore blank cells in a spreadsheet

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Charts in Excel- please help on making charts that ignore blank cells in a spreadsheet

     
    Hi

    I have excel for Mac 2011 and I cant work out how to do this. I did try going to Excel menu>preferences>charts and selecting empty cells not plotted. However I don't even have the option to select this now....any suggestions?

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,400
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Charts in Excel- please help on making charts that ignore blank cells in a spreadsheet

      
    This setting depends on chart type, and for chart types that recognize the setting, whether the cells are really blank or just have a formula that make them look blank.

    For more on this topic, see my tutorial Mind the Gap - Charting Empty Cells.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com