课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,100 门业界名师课程任您挑！

Create a chart of monthly complaints

Create a chart of monthly complaints - Microsoft Excel教程

课程: 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…

内容