Excel Tutorials

We all know that Excel takes dull number figures and makes them eye appealing in graphs and charts, but did you know that you can also jazz up graphs and charts with pictures. You can, and it’s so easy in Excel 2007. In this short tutorial, I will show you how to insert a picture in a pie chart slice.
Please Note: Before formatting the pie chart with a picture, have an idea of what picture you want to use and where you have it located in your computer so that you don’t waste time searching for it when working with the pie chart.

1. Go to Start>Programs>Microsoft Excel. Go to Office>Open to open the Excel spreasheet where you have the pie chart saved.
2. Find the pie chart, and click the slice of the pie chart where you want to insert the picture. Once selected, right click it and go down to Format Data Series. In the “Format Data Series” pop up window box, select the “Fill” option and click on “Select Picture.”
3. Next, click on “File” and find the picture you want to insert within the “Insert Picture” pop up window box. Once you find the picture, hit “Insert” and click OK within the “Format Data Series” pop up window box.
4. Now you can see the picture in the pie chart slice area that you chose.

Pretty Neat! This is just one of the many cool things you can do in Excel 2007.

Posted in Charts | Comments (0)

We can automate a lot of things with excel sometimes though we need to have visual appeal. Using charts to impact our audience instead of plain boring numbers makes sense. Pie charts are one of Excel’s most options used to display number and percentage information. You can actually keep the slices within a pie chart together or select them all and separate them for further impact. But, one feature that we don’t use often is separating just one slice from the pie chart to highlight that specific piece of data. I’ll show you how to create a pie chart and highlight just one part of it in a couple of easy steps.

1. For this lesson, we’ll use salespersons and profit information from a beverage distribution company. First, go to Insert>Chart and the chart wizard formatting box will appear. Under “chart type” select the pie chart and under “chart sub type” select the first image, and click Next.

2. Now select the data range that you want to chart in the pie chart – in this example, select all the salespersons and profits data as seen in the screen shot below, and click Next. Then, click on the “Data Labels” tab and select “Percentages,” so that the profits data is displayed as percentages instead of dollar values. Finally, click Next and select the second option to place the pie chart in the same spreadsheet.

3. Your pie chart should look like the image below. Now click on the actual pie chart so that you can see how the whole pie chart slices are selected – at this point you could drag out all the pieces and they would separate from each other. Now deselect the whole pie chart and click on the light green, 16% slice. Notice that only that slice is selected and drag it out slowly. As you can see it will separate from the pie chart alone leaving the other pieces attached together. The image should look like the last screen shot. You did it! Now you know how to separate just one slice from a pie chart for maximum impact.

Posted in Charts | Comments (0)