+ Reply to Thread
Results 1 to 2 of 2

Charts data values

  1. #1
    Registered User
    Join Date
    11-20-2007
    Posts
    1

    Charts data values

    HELP

    I have this problem

    if I graph the following data, everything comes up ok.

    a1 90%
    b1 80%
    c1

    In the chart, c1 has no data value, which i would assume as it has been left blank

    The problem comes when I am linking these cells from another tab in the workbook,

    If on another tab, I link the following,
    d2 =a1
    d3 =b1
    d4 =c1
    When I graph this, then the data value for d4 is now 0. Why is this. It should be blank as the cell c1 is still empty. Some times I do put a zero percentage in the field so I need it to do both

    Any ideas. Please email to wookie
    [email protected]
    Last edited by VBA Noob; 11-20-2007 at 02:42 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    Try this formula in D4: =IF(C1="","",C1).
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1