Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Create an Excel Chart with One Keystroke

It only takes one keystroke to create a chart from data in Excel.

Select a cell that contains the chart data or a heading.
On the keyboard, press the F11 key
A chart sheet is inserted, with a chart in the default chart type, as shown below.