What’s New in Excel 2007 Charts:-

The following list summarizes the new charting features in Excel 2007:

1. To create a chart, you usually start with one of the seven new galleries on the ribbon’s Insert tab. The first six galleries offer column, line, pie, bar, area, and scatter charts. The remaining chart types—stock, surface, doughnut, bubble, and radar—are grouped in the Other Charts gallery.

2. You can display the All Charts gallery, which shows all 73 chart subtypes.

3. After you have created a chart, you can customize individual elements of the chart by using the Layout ribbon. The Layout ribbon offers settings for the chart title, axis titles, legend, data labels, data table, axes, gridlines, plot area, chart wall, chart floor, 3-D rotation, trendline, lines, up/down bars, and error bars. In each case, a drop-down menu offers the popular choices and a More Options choice leads to a formatting dialog that presents all the choices.

4. If you are in a hurry, you can head to the Chart Layouts drop-down on the Design ribbon. This drop-down offers a number of preset combinations of the elements from the Layout ribbon. The presets vary from chart type to chart type. For example, while there are 10 presets for column charts, there are 12 presets for line charts, and there are fewer for area charts.

5. There is now a gallery of 48 combinations of color and effects. You can choose from the Chart Styles gallery on the Design ribbon to quickly apply a color scheme to a chart. If you don’t like the built-in colors, you can choose a new theme from the Page Layout ribbon, or you can head to the Format ribbon to change the colors for each data series.

6. If you want micro-control over the shape, fill, outline, or effects of any chart element, you can use the Format ribbon.

7. It has always been possible to create a chart with a single keystroke—using the F11 key to build a default chart on a new worksheet. Excel 2007 continues to support this feature, and it also adds Alt+F1 for building a default chart embedded on the current worksheet.

8. In Excel 2003, you could define custom formatting for charts by using Chart Type, Custom Types, User Defined, Add. Excel 2007 replaces this functionality with Chart Type, Manage Templates. The main advantage of this change is that it is now easier to move templates from one computer to another computer.

9. In many galleries and formatting menus, Excel offers a Live Preview feature. You can see the effect of a change by simply hovering your mouse over the menu selection. You will find yourself hovering over several choices until you find one that looks good, and then clicking that option.