+ Reply to Thread
Results 1 to 2 of 2

Chart ignoring formulas but only plotting formula results

  1. #1
    JD
    Guest

    Chart ignoring formulas but only plotting formula results

    I am creating a line chart where the source data is the result of an =IF
    formula. How do I get the chart to only plot the cells where there is a
    result? Currently the chart is plotting a zero value for all the cells where
    the formula does not yet show a result.

  2. #2
    Bernard Liengme
    Guest

    Re: Chart ignoring formulas but only plotting formula results

    If( something, formula, NA() )
    The otherwise blank cells now have #N/A in then (you can hide these with
    Conditional formatting if they bother you)
    Charts ignore these values
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "JD" <JD@discussions.microsoft.com> wrote in message
    news:87ED70A4-957A-453E-A4C5-1223CE533F60@microsoft.com...
    >I am creating a line chart where the source data is the result of an =IF
    > formula. How do I get the chart to only plot the cells where there is a
    > result? Currently the chart is plotting a zero value for all the cells
    > where
    > the formula does not yet show a result.




+ 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