Results 1 to 14 of 14

Link Graphed data to output cells.

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2008
    Location
    Perth, Australia
    Posts
    19

    Link Graphed data to output cells.

    I am trying to get the information that I have plotted, on a scatted graph,
    off onto the second sheet an splitting the information. I'm not too sure if
    this is the right place for this thread, but I am hoping that someone can
    help?

    The original data that is on the graph is in 3 columns. One has the company
    name, one is the current value and one is the predicted value.

    I need this info to come off the graph or from the original data in 2
    fields. Customer and predicted value, but they need to be prioritized.

    1 needs to be the one with the lowest current and highest potential.
    2 needs to be the 2nd lowest current and 2nd highest potential......so on.
    Then I need to get the highest current and highest potential.......so on.

    I know that what I require is quite complex and it may have to be via
    calculations, but I am hoping that excel can do this?
    Attached Files Attached Files

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