New Charting Tools and Menus in Excel 2007:-


The entry point for Excel 2007 charting is the Insert ribbon. After you have created a chart, three new ribbon tabs appear under the Chart Tools heading. The Design ribbon allows you to choose a different chart type, layout, or style. The Layout tab allows you to add various elements to a chart or remove them from a chart. The Format tab allows you to micromanage individual elements, such as the bevel effect for an individual data series. In general, the tabs progress from more general to more specific as you move from the Design tab on the left to the Format tab on the right. Figure (given below) shows the icons on the Design, Layout, and Format tabs.

A few other ribbon tabs come into play when you’re creating charts. If you don’t like the colors used in the Chart Styles gallery on the Design tab, you can visit the Theme dropdown on the Page Layout tab to choose a new theme color for the document.

Also, you can use many of the formatting icons on the Home tab to format titles and labels on a chart. These same icons appear on the mini toolbar when you select text within a title on a chart.



(Global changes occur on the Design tab, formatting of individual elements on the Layout tab, and micro changes on the Format tab.)