Applying Images to a Bar Graph in Excel
Applying Images to a Bar Graph in Excel
1. Click the Clip Art button on the drawing toolbar (If you can’t find it, click View on the menu bar, scroll down to Toolbar, then scroll over and click on Drawing to put a checkmark next to it.)
2. Select an appropriate image and right click on it, then click Copy.
3. Go back to the graph, then click on the markers (bars) and click Edit on the menu bar and select Paste
4. Then, the images will appear as data bars.
5. Select data markers (bars) and right click on the bar, then click Format data series
6. Press Fill effects
7. Select Stretch, Stack, or select Stack and scale to and set scale.
8. See what happens!
9. To choose a picture that you already have on your computer, click on select picture.
10. Then, use the scroll bars to find the picture you would like. Click on the picture and click insert.
To change the colors, patterns, style, and textures of the bars:
11. To select a pattern, click on the pattern tab. Click on the pattern you want and then click OK. To change the color of the pattern, click on the arrow next to the foreground box. Click on the color you want. Then click on the arrow next to the background box and click on the color you want.
12. To select a texture, click on the texture tab. Click on the texture you want and then click OK.
[pic]
13. To change the fill of the bar, click on the gradient tab. To have one color, click on the circle next to one color. Then, click on the arrow next to color and click on the color you want. To have two colors, click on the arrow next to two colors, and then select the color you want again, but you need to do it for both colors.
14. To change the shading of the colors, click on the arrow next to dark if you want it darker. Click on the arrow next to light if you want the color lighter.
15. To change the direction of shading, click the circle next to the style of shading you want.
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.