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
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.
I've manged to solve it eventually
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks