Results 1 to 6 of 6

Question on returning Value from a chart

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2007
    Posts
    13

    Question on returning Value from a chart

    I am having trouble coming up with a formula or way to return a value from a chart. I have messed around with SUM PRODUCT but can not figure out a way to use it effectively. I have attached an example of the chart I am trying to use. What I would like to return is the value in the spreadsheet that falls between the set of criteria. What I would have on a separate spreadsheet would be an increase and an average. I would like to return the cell amount that fits the criteria. For example in the chart if the average is 55 and the increase is 10% i would like it to return $1200. So if it falls between the two values i would like it to use the lower amount. Any help would be appreciated.

    Thanks in advance.

    AVERAGE
    Increase 50 60 70
    0.00% $- $200 $400
    1.50% $200 $400 $600
    3.00% $400 $600 $800
    4.50% $600 $800 $1,000
    6.00% $800 $1,000 $1,200
    7.50% $1,000 $1,200 $1,400
    9.00% $1,200 $1,400 $1,600
    10.50% $1,400 $1,600 $1,800
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bubble Chart Question
    By cbh35711 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2008, 06:15 AM
  2. Pie Chart question
    By vonkoba in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2008, 10:02 PM
  3. Chart Question
    By andrewc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-22-2007, 09:20 AM
  4. formatting excel chart
    By excelguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2007, 09:20 PM
  5. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1