Although Excel Online's charting capabilities aren't as robust as the desktop app's, it does include some built-in chart types. In this video, learn about Excel Online's charting features.
- [Instructor] One of the most commonly used features of Excel Online is charting. And there's a good reason for that. It brings life to your data and the good news is it's dead easy. If you'd like to follow along with me, then have XOL Charting open. Take this example that we're looking at here, which is an extract from a company's chart of accounts. We have a Cost Center, General Ledger Code and an Amount, which is Full Year Actuals. Say that we want to chart just the last two columns, being columns C and D. Let's go ahead and select the data and make sure that you include the header row. Now let's go to Insert. And then select the dropdown box next to Column and select the very first option here, which is the 2D Column Chart. And in just a matter of moments, Excel Online has prepared a column chart on our data. Now, with the chart still selected, check this out. Let's go and select the dropdown box next to the pie chart and select 2D Pie. And without having to delete the existing chart, we were able to convert it from a 2D column chart to a 2D pie chart. Okay. Let's now delete this chart and make sure that the data that we had selected is still highlighted. If not, just simply go ahead and reselect the data. Now let's click on the dropdown box next to Other Charts and select this first one here called Waterfall. Excel Online has created what's called a waterfall chart where each amount, that is each of our expense codes here have been progressively added to the amount before, giving us a total. Finally, let's delete this chart once more. Make sure that the data is still selected. Go back to Other Charts and let's select the second option under Statistical. What Excel Online has done now is created a combination of a column chart for the expense codes and also a cumulative line graph where each amount has been progressively added, giving us a total of 100%. As you can see, charting in Excel Online is dead easy.
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Excel Essential Training (Office 365) or Learning Excel 2019.
- Using Excel Online shortcuts
- Customizing your view
- Integrating the desktop version of Excel
- Sharing workbooks in Excel Online and OneDrive
- Inserting and reviewing comments
- Creating and editing charts
- Working with PivotTables and PivotCharts