Microsoft Office XP - Apply Pictures To Excel Chart Data Points

One way to spruce up dull charts is to replace the typical solid-colored data points with a picture. There are several ways to accomplish this, and we'll look at one of the easiest techniques to use when working with bar or column charts. First, on the chart select the data series you want to format by clicking on it. Then, choose Insert | Picture | From File from the menu bar. Locate and select the picture you want to use--Excel can work with most graphic file formats. Finally, click Insert and Excel applies the picture to each data point, resizing the image as needed. The method we used is easy, but other chart types require different approaches.

Go back