From the course: Microsoft Data: SharePoint, Power Platform, Access, Excel
Join today to access over 23,100 courses taught by industry experts.
Creating charts and graphs in Excel
From the course: Microsoft Data: SharePoint, Power Platform, Access, Excel
Creating charts and graphs in Excel
- [Instructor] Your Excel worksheet consists of thousands of rows and dozens of columns. And you want to give people a quick way to understand what the information conveys. How do you do that? Simple answer, make a chart. Excel has very powerful built in tools to take complex data and create a visual representation. And there are a wide range of different types of graphs and charts available to cover all sorts of different purposes and they make it so easy to get started. I've got this worksheet with sales information. I want to know total of sales that happen in each region by date range. So I'm going to start by selecting the Region column, and then I will select Date of Sale, and I will also select the Total Invoice Amount. Now, I've got the Insert tab on the ribbon menu selected, and you can see there's this whole charts section here, but Excel is smart enough to understand what we might need based on the column selected.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.