Closed Thread
Results 1 to 2 of 2

Excel 2003 - IF formula in Chart

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    29

    Excel 2003 - IF formula in Chart

    Can you do that?

    Attached is a screen shot of the table I am practicing on.

    I have three sheets. The source of my chart is from three different sheets.
    I only want the data (Price and Quantity) of Grape from Sheet1, Sheet2 and Sheet3.

    I would like to ask if I can do an IF(B4:B8="Grape") for the 'Values'

    I don't seem to know how to, since whenever I input an IF function then select the columns, my query erased.

    Okay thanks in advance!
    Attached Images Attached Images

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel 2003 - IF formula in Chart

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed 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