Excel Online includes some built-in tools that make charting simple. In this video, learn how to use Excel Online's chart tools.
- [Instructor] Once we have created an Excel Online chart, we can make the most of charting tools to change the look and feel of the information. In the exercise file that you're looking at here, we already have prepared a basic column chart. Now, the first thing that we may wish to do is move the chart, so using the mouse, I'm just going to drag the chart and move it over here to the right-hand side. I then want to make the chart a bit larger by clicking on the bottom right-hand corner of the chart and resizing it, and then let go of the mouse. And what you'll notice is Excel Online has automatically adjusted the font size in this chart. We can then go ahead and use the charting tools, which appear here at the top of the screen to change the look and feel of this chart. So let's go and select Chart. And the first thing that I want to do is change the chart title to something a little bit more meaningful. So select Edit chart title, and I'm going to give the chart some text that says Distribution of the company's expenditure, and then click on OK. As you can see, the title of the chart has been updated for the text that we just included. The next thing that we may wish to do is include a legend. So click on the dropdown box beneath Legend, and then let's say Show the legend at the bottom. And you'll see that we have a legend that tells us that the blue shaded areas are amounts, full year actuals to be exact. Now, you may notice that there are a couple of limitations in Excel Online. However, if you have Excel Desktop, you can actually go ahead and use it to make additional changes that aren't possible in Excel Online. And the best part is once the changes have been saved there, they will be retained and viewable in Excel Online. What you have learned is how to change the look and feel of Excel Online charts using chart tools.
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