Office 2007 has been out for a while, but I’m still finding commands and features that I seldom use. For instance, recently I found the Chart Wizard in Access 2007. Actually, I wasn’t looking for it, but when I saw its new home, I knew it was a logical move. Finding the wizard in Access baited my curiosity—I put my task aside to find the Chart Wizard in all of the Office 2007 applications.


In Excel 2003, the Chart Wizard is in plain site on the Standard toolbar. Select a range of data, click the button and Excel produces an embedded chart. Starting with 2007, Excel no longer provides a Chart Wizard. Instead, the basic chart types are in the Charts group on the Insert tab. Simply click any chart type and follow the step-by-step instructions for completing the chart. To alter an existing chart, first, select the chart and then use the tools on the context-sensitive Design tab.


Word’s Chart Wizard hasn’t really moved. In Word 2003, you choose Picture from the Insert menu and then choose Chart to launch Microsoft Graph. The Chart Wizard hasn’t really moved in Word 2007 (or 2010). You’ll find it on the Insert tab, in the Illustrations group. If Excel 2007 is installed, Word has access to Excel’s advanced charting capabilities. If Excel 2007 isn’t installed, Word launches Microsoft Graph.

There’s also a tool for organizational charts. Choose Picture from the Insert menu and then select Organizational Chart. Word will display a chart template and the Organizational Chart toolbar. In Word 2007 and 2010, this charting feature is harder to find. It’s in SmartArt, which is in the Illustrations group on the Insert tab. After launching SmartArt, choose Hierarchy in the left pane.


To add a chart to a form a report in Access 2003, you choose Chart Wizard from the New Form or New Report dialog box, respectively. Now, the Chart Wizard is in the Controls group on the Design tab. To add a chart, open a form or report in Design view and click the Chart Wizard. This move makes perfect sense to me.

Like Excel 2003, PowerPoint 2003’s Chart Wizard is on the Standard toolbar. Clicking the tool launches Microsoft Graph. Fortunately, the wizard’s easy to find in PowerPoint 2007 and 2010. It’s in the Illustrations group on the Insert tab. Like Word 2007, if Excel 2007 is installed, the Chart Wizard has access to Excel’s advanced charting capabilities. Without Excel 2007, the chart launches Microsoft Graph.