From the course: Excel: You Can Do This

Unlock this course with a free trial

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

Create basic charts from scratch

Create basic charts from scratch - Microsoft Excel Tutorial

From the course: Excel: You Can Do This

Create basic charts from scratch

(upbeat music) - Let's talk about charts, you all. Excel can make charts and sometimes it helps us when we do our analysis. It's nice to look at a graph instead of numbers on a screen. We've got months and a count of sales transactions. Going to click inside this data set and go to insert. In the charts group, there are a lot of options, but let's select recommended charts. Line graph, no, got a pie chart, no. Let's pick this bar graph. It's called a clustered column formally. Okay. There's our graph. The months along the bottom, the values along the side. We see October had the most. There was over 700. Pretty simple data visualization here, but of course, there's a lot more here. If you go to design, in this design tab, you can change the color palette. Let's change it here, okay? Now we have the purple bars. But there are a lot of other things. We can add a legend, we can get rid of these lines, we can get rid of the title or retitle it. So go in, check out these details. Make up…

Contents