Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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

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
sheana11
Asked:
sheana11
  • 5
  • 5
  • 3
1 Solution
 
Gerwin Jansen, EE MVETopic Advisor Commented:
0
 
GrahamSkanRetiredCommented:
Inset a Rectangle shape and add the text (%). Choose 3-D effects from the Format tab, and select the appropriate 'Perspective' effect.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Yep, just play around a bit, like this:
Excel playing with shapes
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
GrahamSkanRetiredCommented:
Oops, sorry.

 That advice was for Word
0
 
GrahamSkanRetiredCommented:
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
 
sheana11Author Commented:
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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
sheana11Author Commented:
Thank you so much, gerwinjansen!
0
 
sheana11Author Commented:
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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
I don't understand why the answered question is closed with 0 points. Maybe you made a mistake in closing?
0
 
sheana11Author Commented:
Sorry about that, it is 4 am in the morning.....need my coffee. Think I gave you your 500 points.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
No problem, thanks :)
0
 
sheana11Author Commented:
Gerwinjansen, did you get the shape from "AutoShapes" in Excel?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now