Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Saturday, December 3, 2011

Image Trickery

Pictures don’t lie, but they sure can tell tales! They can also serve as the basis for interesting, personal art. “Artistic effects” – tools offered in Microsoft Office 20110 applications – can transform otherwise uninspiring photographs into amazing images.
imageIn other posts I described a number of these tools, in this article I want to take up some of the more unusual effects that are available and further show how you can combine effects for even more effects.
To start here is a mosaic, or “tiled”, picture of a robin. The pixelation effect is called “Light Screen” in “Picture Tools”. It is very dependent on the size of the original image, to get just the right tile spacing may require scaling the photo before inserting it into a Word, Excel, imageor PowerPoint document. This effect was not very impressive when applied to the original photo, so I first used another effect, “Plastic Wrap”. I saved that effect (right-click > “Save as picture…”). “Plastic Wrap” is a rather neat effect, but doing this to a robin might get me in trouble with the animal protection folks. Really, no creature war harmed!
Let’s turn to a less controversial photo subject, a bunch of leaves. Here I applied “Mosaic Bubbles”.image The illustration here is a small portion to show the bubbles better. Now, how about a plastic wrap on this one?
Again a cutout is used to show the effect better in this small blog.
This makes for a totally different look, the bubbles are still there but now they look collapsed and the whole surface is shiny.
imageHow can you use this effect, or effect combination? Well, that all depends on you, the artist. If you like it, it is good.
Now, let’s continue with the trickery. I will stick to my leaves and add a twist.
First some posterizing using the “Cutout” effect. Then, to make it more like a drawing, I add edges with the “Photo Copy” tool. In an earlier article I demonstrated the “Photo Copy” effect – like a very old-fashion copy machine from decades ago. With a good bit of transparency this gives a nice print, or wall paper, effect.
LJK_3697-A
LJK_3697-A-WC2
LJK_3697-A-WC2-PC
The three images here show the progression so far. Remember, after each effect is applied, the image is saved. The image is then replaced in Word with the saved one. This is the way to add effect upon effect.
Now I will roll out the canvas and use the “Texturizer” effect. To continue the trickery I load another image, this one of a small snake, and remove everything but the snake with the “Remove Background” tool. Setting both images to “Text Wrap – Tight” allows one image to be freely dragged over the other one. Here is the result:
snake on leaves-2
One final trick. In Word not only can you superimpose one image on another, you can do the same with text. A picture of an old cabin serves as the base, I won’t tell you all of the effects applied because I lost count, trying one, then another until I was happy with the result. However, the last and predominant effect is “Glow Edges”. Text uses a “Text Effect” to put the glow around the letters.
HappyHolidays-1200
My best wishes to all for a joyous and happy Holiday Season!
Hope you can spare some time to take some great photos, and maybe use these tools to have fun with your pictures.
“Artistic Effects” in the Microsoft Office 2010 applications were demonstrated in these other articles:
  • Painting with Word – the “Paint Brush”, “Marker”, and “ Watercolor Sponge” effects.
  • Doodling in Officepencil and drawing effects.
  • Excel in Art – the effects called “Cement”, “Glass”, “Glow Edges”, and “Cutout”.
.:.
© 2011 Ludwig Keck

Monday, November 7, 2011

Excel in Art

Of course, you can! But this is not about helping you to the pinnacle as an artist, this article is really about “Art in Excel”, Microsoft Office 2010 Excel to be a little more specific. ExcelArt-01Like Word and PowerPoint, Excel provides the same “Picture Tools” with, among many other options, “Artistic Effects”.
Painting and drawing transformations were discussed in earlier posts (see bottom of article). Here I wish to take up a few of the more unusual and interesting effects.
Before I dive in, there are some technical details I must cover. When applying the artistic effects in Office application only one can be used. So you select the one you want and that’s it. There is also the question of how you get your masterwork out of the program. ExcelArt-02There is a bit of bad news, but first the good news. In Word 2010 just right-click the modified image. The new menu has an option “Save as Picture…” with permits you to save the image in its original size – full resolution.
This option is not available in either Excel 2010 or PowerPoint 2010. In those applications you can use only “Copy”. This command is like doing a screen capture of just the picture, the copied image is just the displayed size. So you must make sure that you have displayed the image in a sufficient size on your monitor to get adequate resolution.
Many of the effects are sensitive to the size of the inserted picture. The effects typically are less effective on large photos and show up much more noticeably on smaller images.
ExcelArt-04
The illustration above uses the “Glass” effect on the photo of the flower. The effect is adjustable in “Scaling” which was set to 100 for both the larger image (inserted from the original size) and the smaller image which was reduced in size prior to being inserted. You can see the marked difference. This does provide you with wider options for creating your art.
Lets look at a different effect on this same set of photos: “Glow Edges”.
ExcelArt-06
Once again you can see the different “effectiveness'’. Both images use the default setting of “Smoothness” of 3 (scale ranges to 10) with 15% transparency.
LJK_2977-Art-C-C3-2An effect that I find particularly appealing and useful is “Cutout” which is more commonly known as “posterizing”. This effect translates a photo into graphic areas as they might be used in a poster painting. Here is a picture that shows that effect well. You can select “Number of shades” from 0 to 6. This image uses 3 “shades”.
A little higher up, I slipped in one other effect, “Cement”. That effect makes a photo look like it was printed on a rough cement surface. There is also a canvas type “Texturizer” surface offered.
Now with all these art tools in Excel is there any reason to think that you cannot excel in art?
Some of the other “artistic effects” available in the Office programs are discussed in other posts in this small series:
  • Painting with Word – the “Paint Brush”, “Marker”, and “ Watercolor Sponge” effects.
  • Doodling in Officepencil and drawing effects
  • Image Trickery – effects “light Screen”, “Mosaic Bubbles”, “Plastic Wrap”, “Texturizer”, and combining of effects.
.:.
© 2011 Ludwig Keck