| Chart Feature |
In Excel 97-2003 |
In Excel 2007 |
| The Chart Wizard |
You can use the Chart Wizard to create a chart. |
The Chart Wizard is no longer available.
To create a chart, on the Insert tab, in the Charts group, you simply click the chart type that you want. After creating the chart, you can then use the Chart Tools to add chart elements, or change the layout and formatting of the chart.
For more information, see Create a chart.
|
| Simultaneous resizing of multiple charts |
You can change the size of multiple charts simultaneously. |
You must change the size of each chart individually.
For more information, see Move or resize a chart.
|
| Duplicating chart sheets that contain data |
When an existing chart sheet that contains data is selected, you can press F11 to create a chart sheet with the same data. |
You can no longer duplicate chart sheets that contain data by pressing F11.
Pressing F11 when an existing chart sheet that contains data is selected creates a new chart sheet without data.
For more information, see Create a chart.
|
| Changing the rotation of 3-D charts |
You can change the rotation of a 3-D chart by using the mouse. |
You cannot use the mouse to change the rotation of a 3-D chart.
You can only change the rotation of a 3-D chart by specifying settings in the 3-D Rotation category in the Format Chart Area dialog box.
For more information, see Change the display of a 3-D chart.
|
| Using pattern fills in chart elements (for black-and-white printing and to improve readability for the visually-impaired) |
You can use pattern fills in chart elements. |
Instead of pattern fills in chart elements, you can use picture and texture fills.
Charts with pattern fills that were created in an earlier version of Excel appear the same when they are opened in Excel 2007, but you cannot use the pattern fills in other chart elements.
For more information, see Change the shape fill, outline, or effects of chart elements and Microsoft Excel Blog: Chart pattern fills.
|
| Sizing charts with the window |
You can use the Size with window command to automatically resize charts that are located on chart sheets (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) when you change the size of the window. |
Instead of the Size with window command, you can use the Zoom to Selection command to achieve similar results.
For more information, see Zoom in or out of a document, presentation, or worksheet.
|
| Automatically creating a text box when you type on a chart |
A text box is automatically created when you click anywhere on a chart and start typing. |
You cannot create a text box when you click anywhere on a chart and start typing.
For more information, see Add a text box to a chart.
|
| Copying charts to Microsoft Office Word 2007 and Microsoft Office PowerPoint 2007 |
By default, a copied chart is pasted as a picture in an Office Word 2007 document or Office PowerPoint 2007 presentation. |
By default, a copied chart is pasted in an Office Word 2007 document or Office PowerPoint 2007 presentation as an object that is linked to the Excel chart.
You can change the way that a copied chart is pasted by clicking the Paste Options button that is displayed when you paste the chart, and then pasting the chart as a picture or an entire workbook.
For more information, see Copy Excel data or charts to Word or Copy Excel data or charts to PowerPoint.
|
| Using a Word table as a data source |
You can use a Word 97-2003 table as data for a new chart. |
A table in Office Word 2007 cannot be used as data for a new chart.
When you create a chart in Office Word 2007, you get a worksheet with sample data instead of the data in the selected Word table. To plot the Word table data into the new chart, you need to copy that data to the worksheet, replacing the existing sample data.
For more information, see Copy a Word table into Excel.
|
| Specifying printed chart size and scaling |
You can specify printed chart size and scaling options on the Chart tab of the Page Setup dialog box. The Chart tab is available only when a chart is selected (File menu, Page Setup command). |
The printed chart size and scaling options are no longer available on the Chart tab of the Page Setup dialog box. The Chart tab is available only when a chart is selected (Page Layout tab, Page Setup group, Dialog Box Launcher  .
For more information, see Print a chart.
|
| Dragging worksheet data to the chart |
You can add data to a chart by selecting the data in the worksheet and dragging it onto the chart. |
You can no longer drag data from a worksheet to a chart.
You can use other methods to add data to a chart.
For more information, see Update the data in an existing chart.
|
| Dragging data points on charts |
You can drag data points (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) on a chart and change their source values on the worksheet. |
Dragging data points to change the source values on the worksheet is no longer supported. |
| Grouping and selecting shapes |
Shapes are drawn in a format that differs from the shape format that is used in Excel 2007. |
Shapes that are drawn in earlier versions of Excel cannot be grouped with shapes that are drawn in Excel 2007, even when the shapes are upgraded to the current version. You cannot select shapes that are created in different versions of Excel at the same time. Shapes that are created in different versions of Excel are layered on top of current shapes.
Much like shapes, charts that are created in Excel 2007 cannot be layered on top of dialog sheets that are created in earlier versions of Excel, and you cannot view charts that are layered underneath these dialog sheets.
To select the current charts, use the chart element selection box (Chart Tools, Format tab, Current Selection group).
To select hidden charts or shapes that were created in an earlier version of Excel, you must first add the Select Multiple Objects command to the Quick Access Toolbar.
For more information, see Customize the Quick Access Toolbar.
|
| Sending a chart in an e-mail message |
When sending a workbook, you can choose to e-mail just a chart by using the Send this Chart command in Office Outlook 2003. |
The Send this Chart command is no longer available in Office Outlook 2007.
Instead, you can copy and paste a chart into an e-mail message, with or without the worksheet data.
For more information, see Copy a chart.
|
| Setting shadows on chart elements with area fill set to none |
You can set realistic shadows on chart elements with area fill set to none. |
The shadows on chart elements with area fill set to none do not look the same.
For more information, see Microsoft Excel Blog: Shadows on charts and cells in Excel 2007.
|
| Recording chart shapes and shape formatting in a macro |
You can record changes to chart shapes and formatting in a macro. |
You cannot record changes to chart shapes and formatting in a macro.
For more information, see You cannot record new shapes, shape formatting, and shape effects by using the macro recorder
|
| Using drop zones in PivotChart reports |
PivotChart reports contain drop zones for Row, Column, Data, and Page fields. You can drag fields between drop zones or from the Field list. |
Pivotchart reports no longer have drop zones, but you can change the layout of the PivotChart by changing the layout of its associated PivotTable report through the PivotTable Field List.
For more information, see Create and change the field layout in a PivotTable report.
|
| Using Page, Data, Series, and Category drop-down lists and buttons on a PivotChart report |
You can control the layout and appearance of a PivotChart report from the chart by using assorted drop-down lists and buttons to filter, sort, and rearrange the data. |
These drop-down lists and buttons have been removed from the PivotChart report and moved to the PivotChart Filter Pane. For more information, see Overview of PivotTable and PivotChart reports and Change the summary function or custom calculation for a field in a PivotTable report. |
| Using built-in custom chart types |
Several built-in custom chart types are installed with Excel. |
There are no built-in custom chart types, however, you can easily create your own custom chart types, by saving your favorite charts as chart templates.
For more information, see Reuse a favorite chart by using a chart template.
|
