From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Create a chart of monthly complaints

Create a chart of monthly complaints - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Create a chart of monthly complaints

- [Instructor] You and I have a small company and we've been handed this summary of complaints about us and website between January and April. But these numbers, they don't mean a whole lot. It would be better to have a graph, and this is where you can help. We would like a clustered column chart of the complaints with the months on the X-axis and the number of complaints on the Y-axis, and title the chart, Complaints: January through April. So go ahead, pause the video, make the chart, come back and I'll show you a solution. Okay, I'm gonna put my cursor inside the data set. Go to insert. Over here, I'm gonna click this arrow next to the column charts. Clustered column. Select that, and we have our months on the bottom, and the number of complaints on the side, that's exactly what we want, and then we can click inside this cell, and then rename it. Complaints colon. Check out the broken website links. Those have gone down significantly. We've got something meaningful. We've got our…

Contents