From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Tips for creating charts quickly

Tips for creating charts quickly - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Tips for creating charts quickly

“

- [Instructor] Despite the fact that Excel's charting capability has many, many options and choices, you can create a chart very quickly with just a few keystroke shortcuts and some minor adjustments. On this worksheet here, I'd like to create a chart based on the data here. Including the labels on the top and on the left-hand side. I don't want to include the totals. And I'm in a hurry. Two quick keystroke shortcuts allow us to create charts. For a chart on a separate sheet, simply press the function key F after you've highlighted the data. And there we see a chart on a new sheet, just to the left of the worksheet than contains the data. There's that contextual Design tab, and Format tab with lots of options relating to charts. You might want to print the chart from here. If you're making a presentation with the chart, you might want to do this here without showing the data. I think it's more likely though that you'd…

Contents