Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
RicP
 
Posts: n/a
Default Looking for a U.S. map you can click on state for sales figure?

I am looking for a tool or product where I can convert sales figures from an
excel spreadsheet to a map of the United States you can click on each state
for figures/statistics for each state. Any suggestions out there?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default Looking for a U.S. map you can click on state for sales figure?

RicP

I found several USA state images that you could use with Google. I added a
hyperlink to the Ste name and linked it to range name for state - associated
with data.

http://en.wikipedia.org/wiki/Image:M...tate_names.svg

This one is just one of many. Look till you find the one that fits your
need.

I used SnagIt to copy image and paste to a blank Excel worksheet. Then I
started adding my link.

....Kelly






"RicP" wrote in message
...
I am looking for a tool or product where I can convert sales figures from
an
excel spreadsheet to a map of the United States you can click on each
state
for figures/statistics for each state. Any suggestions out there?



  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Looking for a U.S. map you can click on state for sales figure?

Hi,

You maybe able to adapt this.
http://www.andypope.info/ngs/ng12.htm

Cheers
Andy

RicP wrote:
I am looking for a tool or product where I can convert sales figures from an
excel spreadsheet to a map of the United States you can click on each state
for figures/statistics for each state. Any suggestions out there?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Posted to microsoft.public.excel.charting
RicP
 
Posts: n/a
Default Looking for a U.S. map you can click on state for sales figure

Kelly, thank you so much for your input and suggestions.

"Kelly O'Day" wrote:

RicP

I found several USA state images that you could use with Google. I added a
hyperlink to the Ste name and linked it to range name for state - associated
with data.

http://en.wikipedia.org/wiki/Image:M...tate_names.svg

This one is just one of many. Look till you find the one that fits your
need.

I used SnagIt to copy image and paste to a blank Excel worksheet. Then I
started adding my link.

....Kelly






"RicP" wrote in message
...
I am looking for a tool or product where I can convert sales figures from
an
excel spreadsheet to a map of the United States you can click on each
state
for figures/statistics for each state. Any suggestions out there?




  #5   Report Post  
Posted to microsoft.public.excel.charting
RicP
 
Posts: n/a
Default Looking for a U.S. map you can click on state for sales figure

Andy, thanks you for your input and suggestions.

"Andy Pope" wrote:

Hi,

You maybe able to adapt this.
http://www.andypope.info/ngs/ng12.htm

Cheers
Andy

RicP wrote:
I am looking for a tool or product where I can convert sales figures from an
excel spreadsheet to a map of the United States you can click on each state
for figures/statistics for each state. Any suggestions out there?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting and copying automatically between worksheets nadia New Users to Excel 2 February 12th 06 10:18 PM
Calculated fields in pivot tables Nigel Drinkwater Excel Worksheet Functions 5 January 3rd 06 05:41 PM
Why double click on row line moves me on the end of sheet? Marek Zitnansky Excel Discussion (Misc queries) 1 December 28th 05 03:23 PM
how to type a minues figure jenniss New Users to Excel 1 February 8th 05 03:05 PM
Want to click on 1 cell and have it hyperlinked to a highlighted c GutterPunk Excel Worksheet Functions 1 January 31st 05 04:20 AM


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"