Solved

Can you tell me how this word art was created in MS Excel?

Posted on 2012-04-05
13
295 Views
Last Modified: 2012-08-15
How did this person get the percent sign to "reach out" or zoom out at you? How did they get the gradient color fill in the blocks of cells? Any help would be appreciated. Thanks in advance.Worksheet Word Art
0
Comment
Question by:sheana11
  • 5
  • 5
  • 3
13 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37814295
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37814318
Inset a Rectangle shape and add the text (%). Choose 3-D effects from the Format tab, and select the appropriate 'Perspective' effect.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37814342
Yep, just play around a bit, like this:
Excel playing with shapes
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37814344
Oops, sorry.

 That advice was for Word
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37814435
The Excel 'Perspective' doesn't seem to work in the same way that Word does.

You could try adding two freeform triangle shapes to the rectangle (or text box). One would share one side with the top of the rectangle, with the other corner above and to the right of the rectangle. The other triangle would be on the right-hand side, with the same position for the third corner. Then fill the two triangles with slightly different colours.
0
 

Author Comment

by:sheana11
ID: 37815066
Gerwinjansen, can you give me the exact steps you took to create the first shape effect on the left with the yellow percent sign? Thanks in advance.
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 500 total points
ID: 37817113
Here's how you do it:

- insert a shape, rounded rectangle
- double click shape and type % - change font, size and color of text to your liking
- select shape and from shape styles choose 3d rotation
- choose shape style for example off axis 2 left
- right click shape and choose format shape
- at 3-D format increase bottom height to 300pt

Happy 'styling' ;)
0
 

Author Comment

by:sheana11
ID: 37818822
Thank you so much, gerwinjansen!
0
 

Author Comment

by:sheana11
ID: 37818865
I've requested that this question be closed as follows:

Accepted answer: 0 points for sheana11's comment #37818822

for the following reason:

Went above and beyond the call of duty to help me.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37818866
I don't understand why the answered question is closed with 0 points. Maybe you made a mistake in closing?
0
 

Author Comment

by:sheana11
ID: 37818902
Sorry about that, it is 4 am in the morning.....need my coffee. Think I gave you your 500 points.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37818921
No problem, thanks :)
0
 

Author Comment

by:sheana11
ID: 38296012
Gerwinjansen, did you get the shape from "AutoShapes" in Excel?
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question