Creating a professional looking chart for Excel presentations is extremely easy in Excel 2007. Making charts is a more interesting way to present data than just going through the rows and columns on a spreadsheet.
First highlight the data you want to chart on your Excel spreadsheet.
Now that we have the correct data selected we need to click Insert on The Ribbon. Now select Charts and decide what type of chart you want to represent the data. I usually experiment at this point because you can always undo a certain selection.
In this example I used the Exploding Pie Chart. After you make your selection you will get a nice preview of how it looks. Now we can take this chart and move it anywhere on the Excel document.
Next we want to tweak it a bit more by going to the Design tab in The Ribbon and clicking on Quick Layout. Here we can choose from different types of layouts for the chart. Again here you can experiment until you get the right fit.
This is the layout I ended up with. Now lets individualize the chart title by right clicking “Chart Title” and selecting Edit Text.
That is all there is to it! As you can see we have a nice looking chart to help everyone at the meeting understand the data and statistic easier. Later this week I will go over adding details to the chart.
**Also, for you Keyboard Ninja’s a quicker way to execute this process is to highlight the data on your spreadsheet and hit the F11 key. This will bring up a separate “Chart Tab” where you can then manipulate the appearance and add details.
- Published 06/5/08