Note that in the discussion below, menu items may vary somewhat among different Excel versions
I received a request to show how to add a background image to an Excel chart to dress it up. Here is the step-by-step procedure to do that.
The standard Excel chart looks like this (see below)
But it can easily be made to look like this (see below)
If you prefer the former, then read no further. But if you want to dress it up, here are the steps.
Left click within the chart plot area to select it, then right click and select "Format Plot Area..." to get the following menu.
.
Click on "Fill Effects..." to get the following
Click on the "Picture" tab to get the following
Click "Select Picture..." to get the following
Navigate in the menu structure of your to find the picture you want to use (located on your computer's drive), then click "Insert" and hit "OK" two times
Voila! That's it for the background picture.
Now
to dress up the borders...
Repeat the above steps except select the entire chart area and then in the "Fill Effects" menu, select "Texture" instead of "Picture" and then scroll down until you find the texture you like. Here is the final result
The hard part is collecting the data and creating the chart so why not go the extra step and apply the window dressing.
Visit www.KauaiRocks.com
Comments(35)