||In Excel 97-2003
||In Excel 2007
||You can use the Chart Wizard to create a chart.
You create a chart by clicking the chart type that you want on the Office Fluent user interface Ribbon (Insert tab, Chart group). After creating the chart, you can use the Chart Tools to modify and format 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.
|Duplicate chart sheets that contain data
||When an existing chart sheet that contains data is selected, you can press F1 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.
|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
||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.
|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.
|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.
To add a text box on a chart, use the Insert Text Box command.
|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.
|Printed chart size
||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.
|Drag and drop data
||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.
|Direct manipulation of 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.