Apr 25 2006
return of ‘in a state’
The graph-map thingy below shows USA States that I have
- explored a bit (lilac)
- got lost in an airport (pink)
- probably flown-over (yellow)
apologies to the 3 United States (Hawaii, Alaska, Britain) not included in this Excel MapPoint thingy.
return of ‘in a state’
Cool! Did you use the MapPoint control inside Excel?
On my work supplied laptop I
1) looked in Excel Chart Wizard under ‘area’ graphs. Darn. nothing helped me. Gave up.
2) can’t remember what i did but it resulted in a MapPoint map of the US being inserted into Excel. In the time it took me to drink 4 calming 16oz mugs of Tea I failed to find a way to make the data I had show-up in this map. I gave up.
3) Opened MapPoint, discovered I could have ‘territories’ based on geographic regions (selected states) and assign a colour and name to them. Did this. Saved the result as a jpg, resized it, FTP’d it to my web server, opened wordpress, made blog entry, inserted link to jpg. It was easy but still took 4 16oz mugs of tea because it took so long.
Excel gave me a pointer to a cumbersome solution route. Excel did not show me how to use my pre-existing table with titles and States labeled. BOOOOO!!!!
Now the work supplied laptop with MapPoint on it has been taken away by the IT department because it was very naughty this morning… Naughtiness required 8 calming16oz mug of tea in 90mins with no tea ending up on the Laptop. The good news is that I’ve seen some-one with a Tablet-PC that I can probably purloin temporarily while my Laptop is bieng interrogated…..
Was this really a comment or another blog entry? I must learn to stop waffling on….
Can I just say, that you are obsessed with graphs and charts and the like? Which is totally cool (or brilliant!), but also completely random. I just never know what I’m going to see when I click you, is all!
I thought Britain and Texas were Nation States and Mexico was part of the US. Oh!