Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

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

Posted on 2012-04-05
Medium Priority
313 Views
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.
0
Question by:sheana11
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5
• 5
• 3

LVL 38

Expert Comment

ID: 37814295
0

LVL 76

Expert Comment

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 38

Expert Comment

ID: 37814342
Yep, just play around a bit, like this:
0

LVL 76

Expert Comment

ID: 37814344
Oops, sorry.

0

LVL 76

Expert Comment

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

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 38

Accepted Solution

Gerwin Jansen, EE MVE earned 2000 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

ID: 37818822
Thank you so much, gerwinjansen!
0

Author Comment

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 38

Expert Comment

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

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

LVL 38

Expert Comment

ID: 37818921
No problem, thanks :)
0

Author Comment

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

## Featured Post

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
###### Suggested Courses
Course of the Month10 days, 1 hour left to enroll