+ Reply to Thread
Results 1 to 3 of 3

Chart to display only data with values and 0 (Blanks not to be shown)

  1. 02-14-2024, 07:20 AM #1
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Chart to display only data with values and 0 (Blanks not to be shown)

    Hi,

    Need help in making chart with data and "0"s. Blanks are not to be shown.

    An excel file attached with necessary details.

    Pl. help.

    Thanks,
    Nagesh.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-14-2024, 07:22 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Chart to display only data with values and 0 (Blanks not to be shown)

    You have several previous threads that have not been marked as solved - please would you do the necessary housekeeping? Thank you.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-14-2024, 07:42 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Chart to display only data with values and 0 (Blanks not to be shown)

    Excel treats "" as zero. use NA() to get data points excluded from chart.

    Use Conditional formatting to mask #N/A if them showing is an issue.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Need zero values to not be shown on pivot chart please
    By shanemoore in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-19-2020, 12:26 AM
  2. Pivot calculated fields, summaries, and values shown on chart issue
    By LewisBosworth in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-14-2019, 07:23 PM
  3. Problem with current values and forecasted values to be shown in the same line chart
    By mils in forum Excel General
    Replies: 1
    Last Post: 01-03-2018, 12:51 PM
  4. Chart only data with values in Table (ignore blanks)
    By Akshay in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-09-2017, 06:50 AM
  5. Display Chart values in Thousands (and keep data as full number)
    By xtinct2 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-09-2015, 01:27 PM
  6. Chart with VBA data not shown properly
    By adyan76 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2008, 04:22 AM
  7. [SOLVED] How come I only get 4 variables shown on my data table in chart?
    By Ditchboy434 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-08-2006, 11:55 AM

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