How to Use Graphics to Represent Data Series in Excel

Step-by-Step Guide

1. 1

   Step 1: Create your bar chart as usual;

   Excel displays a Context menu. , Excel displays the Format Data Series dialog box ,, The options in the dialog box are expanded to reflect your choice., Excel displays the Insert Picture dialog box, which is very similar to a standard Open dialog box.,, Excel closes the Insert Picture dialog box and re-displays the Format Data Series dialog box.,,
2. 2

   Step 2: Right click on one of the data series bars in the chart.

3. 3

   Step 3: Choose Format Data Series from the Context menu.

4. 4

   Step 4: Make sure the Fill option is selected at the left of the dialog box.

5. 5

   Step 5: Click Picture or Texture Fill.

6. 6

   Step 6: Under Insert From

7. 7

   Step 7: click File.

8. 8

   Step 8: Use the controls in the dialog box to locate and select the picture you want to use.

9. 9

   Step 9: Click on Insert.

10. 10

    Step 10: Choose how you want the graphic to be applied to the bar.

11. 11

    Step 11: Click on OK in each open dialog box to close them.

Detailed Guide

About the Author