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.
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.
June 6th, 2008 at 9:32 am
ALT +F1 works too.
This way you can select a specific data range. Press ALT +F1 and the rest is as above.
June 6th, 2008 at 9:51 am
Thanks for the tip! And that's a good point -- you could also select a specific data range when using the F11 shortcut.