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
Posted on May 21st, 2008 by Debra Dalgleish
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.
Filed under: Charts, Excel, Keyboard Shortcuts
Comment from RLM
Time: June 6, 2008, 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.
Comment from contextures
Time: June 6, 2008, 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.