chart without "0" and blank
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: chart without "0" and blank

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    hello,
    I have difficulty doing lines chart without graphing "0" or "blank" in the graph with MS Office 2000. I am wondering if anyone here know how, I am very grateful.
    Here is the problem:
    10 cells directly to graph are in sheet1, and those 10 cells data are reference to 10 cells in sheet2. If I enter values in any of 10 cells in sheet2 that sheet1 references to, it will shown identical values in sheet1 otherwise it shows blank(s)
    For test purposes, I entered values in that 9 cells and leave one cell blank in sheet2, sheet1 shown the same and the graph graph the data in sheet1 treats the blank cell as "0" value.
    I have tried CHART/plot empty cells as 'not plotted' and 'interpolated' but the graph still graph it as "0".
    Anyone know the way around this, im greatly appreciated.
    minharnold@yahoo.com

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try placing #N/A in your sheets2 data cell


    Ivan

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks for responding, Ivan. I cant do #N/A or other characters because those data cells also in calculations for other sheet.

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