From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Chart efficiency tips: Create, transpose, add titles, adjust gap width, change layouts

Chart efficiency tips: Create, transpose, add titles, adjust gap width, change layouts - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Chart efficiency tips: Create, transpose, add titles, adjust gap width, change layouts

“

- [Narrator] When you create a chart in Excel, there are tons of options and for some people that's a huge problem, because there are just so many options. But there are a couple techniques and we see 'em in the lavender panel on the right side. Some quick and efficient techniques for creating charts. First of all, the two charts that are here are based on the data off to the left, highlighted in blue. Let's create another chart. Remind ourselves you can create a chart immediately simply by pressing either F11. That'll create a chart on a new sheet, just like that. You can work with the chart there. You have all the menu capabilities needed. You're not focused on the data at this point, that's certainly possible. Let's go back to the data. I tend to prefer charts on the worksheet. So, data's highlighted. Alt + F1 using the function key F1. There it is. It's likely to be a column chart unless you've changed the…

Contents