+ Reply to Thread
Results 1 to 3 of 3

Thread: Graph from Imported Data

  1. #1
    Registered User
    Join Date
    09-12-2007
    Posts
    7

    Graph from Imported Data

    I am trying to make a graph from imported data from a web query, the numbers will not be recognized as numbers, so the graph application just ignores them, I can't find anyway of getting them recognized as numbers but still update automatically.

    you can dl the file here: www.ask-crab.com/test.xls

    I want to make the graph from columns H and I

    Thanks,

    Richard

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    841
    You've got to make the months unique. "January". Is that January 2006 or January 2007? You can't tell. Instead of using just months use the year as well. Try converting the month names to yearmonth values like:

    200601, 200602,... 200612, 200701, 200702...

    and use those values in the graph
    Regards
    Special-K

    I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.

  3. #3
    Registered User
    Join Date
    09-12-2007
    Posts
    7
    I've manged to solve it eventually

+ 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.2.0