Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Pictures in Excel Chart Elements

Wednesday, August 5th, 2009 by | Filed Under: MS Excel
 
Loading...


So, when you’re working with charts in MS Excel are you looking for a way to make your audience take notice?

I’d bet that by now you’ve tried just about every color combination you can think of to give your creation a look that grabs attention.

If this is you and you’re looking for yet another way to make those charts “pop” in the eyes of the viewer then may I suggest you add a few pictures?

No, I’m not suggesting that you simply put a picture or two in the corners of the chart… I’m actually suggesting that you change the elements of the chart into pictures.

Maybe turning something like this:


image

Into this:

image

Interested?

Yeah, I thought so. Let’s get started.

Obviously, you’ll need to create an Excel chart. (This works on most charts – not just the bar charts – but for simplicity’s sake I’ll just refer to chart bars even though it applies to other shapes like pieces of pie charts.)

With that done you’ll need to select one or all of the chart pieces to be changed. For example, to select all bars click on any bar. To select a single bar click once on a bar, wait a second then click again on that same bar.

With the bar(s) selected it’s time to start changing the view.

As expected, I have different instructions depending upon the version of Excel you’re using…

Let’s start with older versions of Excel.

You’ll need to double-click on the selected bar(s).

This will open the Format Data Series dialog box.

image

Now you need to click the Fill Effects button below the color palette.

At this point you should be looking at the Fill Effects dialog box.

image

Navigate to the Picture tab and click the Select Picture button.

This will open the same dialog box you see every time you try to locate a file.

Locate the picture file of your choice and click Insert.

Once back in the Fill Effects dialog box click OK, and then click OK one more time to exit back out to your Excel workbook.

You should be looking at a very “pretty” chart with the chosen picture in place of the plain old color schemes.

Now it’s time for my Excel 2007 users.

While you still have the bar(s) to be changed selected you’ll find that the Chart Tools will be available on the Ribbon.

You need to go to the Format tab within the Chart Tools on the Ribbon.

image

We’re now looking for the Shape Fill button. Choose Picture from the list of options displayed.

This will immediately take you to the same type of dialog box we always use to locate files.

Locate the file that you want and click Insert.

This should take you back out to your workbook where you’ll find the “new” version of your chart.

Obviously there are some limitations to this – pictures will be stretched, shrunk and cropped to fit in the bar or pie piece – therefore you may be unhappy with the results when trying to use complex pictures. Never forget your handy Ctrl + Z to undo a change that you don’t like.

Also, you should keep in mind that while jazzing it up is good, too much will make it difficult to read or even distracting to the viewer.

Basically, choose wisely and you should find that you are quite pleased with the results.

So… if a picture is worth a thousand words then this trick must be worth at least double that… right?

~ April

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: