Create Excel shape from MapInfo *OR* make picture background transparent?

Joined
Mar 23, 2004
Messages
241
Hi all.

Further to an original thread (http://www.mrexcel.com/forum/showthread.php?t=335897), I have a question regarding shapes and images in Excel.

Basically, I'm trying to make a map of 14 regions where each region changes brightness depending on values in the worksheets. I think I've got this bit sorted. I'm planning on creating the map using a collection of tessellated shapes or images, and using VBA to alter the properties of each one to create a dynamic map.

The output of the individual maps from MapInfo, our GIS software, is in .png or .jpg. format, and come with a white background. Is there any way to either make the background transparent so multiple shapes can be tessellated effectively, or a way to crop the image to the area's border?

Either that, or does someone know a way to output from MapInfo in such a way to make this possible? (Granted, it's a long shot, but you can't blame a guy for trying...)

Any help would be immensely appreciated. Sorry if I've not explained it well, but hopefully you'll get the drift. :)

Thanks,
CSBBB.
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,166
Hi BOB

Not sure if this helps (As im not sure i understand the question).....

But if its the same problem i have (Which im not sure it is :) )...

To 'cut away' the background i use the crop tool in Microsoft paint as rather than just cropping the size, i can crop 'around' my shape.

I then just put the pitcure back into excel or in my case powerpoint.

This probably doesnt help but just in case it does!
 
Joined
Mar 23, 2004
Messages
241
Hi.

Thanks very much for the response. I'd tried that, but it only seems possible to do a rectangular shape around the image (unless I've missed something).

The shapes I'm using, like most geographical areas, are extremely irregular and need to fit right next to each other, so cropping into a rectangular shape doesn't really work for my needs. Thanks for taking the time to respond, though, if you have any other ideas, please let me know!

Cheers,
CSBBB
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,166
Very welcome-

seeing as i am on the right lines ill try help some more-

Take a picture an stick it in MS Paint.
Down the left handside where you have all the buttons the graffiti icon an so on...

the top right is crop rectangle
the top left i think is crop free form.
Draw round your shape- copy it an put it on a word doc
repeat for each picture
put them all into MS paint
Piece them all together
Crop the whole lot
Put in excel
You will still have the rectangle border when back in excel but you will have pieced all the map pieces together

Sorry i cant help more i dont have paint on this PC so cant be specific
 
Joined
Mar 23, 2004
Messages
241
Ahhhhh. I see where we're at cross purposes. Sorry, I'm sleep deprived today, so clarity isn't my strong point. :(

Rather than creating one big picture with them all in, I actually need them all to stay as independent pictures (albeit reassembled to look like one big picture), so that I can vary each one's brightness and contrast to show how each region is performing.

I tried using that free-form select thing you were talking about and then pasting it directly into Excel, but it still insisted putting a rectangular border around it, so I was back at square one (no pun intended).

Thanks again for your input, and sorry for the confusion.
 
Last edited:

LraeSinned

New Member
Joined
Aug 12, 2008
Messages
47
On project I did a long time ago I needed to have overlapping images and control what part of each image was visible during the presentation.

Each picture had a square border but I was able to define shapes within the pictures and turn the area outside my shape to transparant using Paintshop.

Then I stacked them in Powerpoint and used the ORDER mode to bring each one to the top so I could adjust the positioning. Once I had all the layers set right I grouped them so they couldn't get bumped around.

Maybe something like this would work for you.
 

Gunswick

Board Regular
Joined
Jun 18, 2008
Messages
179
you probably need a graphics design programme, such as Corel draw or similar (even freebies may be able to do this? such as photoshop ?)
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,351
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If you have MapInfo, can you not simply colour the states according to the values by state?
 
Joined
Mar 23, 2004
Messages
241
Hi again.

Adamc, I'm not sure that one works for me either, unfortunately, but thanks for the pointer, I agree it looked promising! :)

LraeSinned/Gunswick, thanks for the tip, but unfortunately I work for a public body, so the luxury of a decent graphics program isn't available to me at the moment. I've got a choice of MS Office programs, Paint or, er, Solitaire. ;)

However, I believe that someone in our marketing department might have a copy of Paintshop, but they're not in today. When they return, I'll try it out and report back here whether it gets me anywhere. Thanks for the lead, though.

In the meantime, if there are any additional suggestions anyone has, I'd be much obliged as always...

EDIT: Rorya - well, yes, but as this is a quarterly report generated for 14 regions from 28 indicators. I'd like to automate it as much as possible. What is it they say? Sloth is the mother of invention... Plus, I'd quite like this to be useable for different projects asa template, so a map would be a nice addition.

Thanks for replying to the post anyhow. :)
 
Last edited:

Forum statistics

Threads
1,082,346
Messages
5,364,822
Members
400,814
Latest member
gangstar67

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top