Instructor Josh Rischin provides a brief introduction to charting in Excel Online.
- [Instructor] One of the most commonly used features…of Excel Online is charting, as it really brings life…to your data, and the good news is it's easy.…If you'd like to follow along, open up XOL Charting.…Take this example, which is an extract from a company's…chart of accounts.…We have a cost center, a general ledger code,…and an amount, in this case, full year actuals.…Highlight the data in columns C and D…and make sure that you include the header rows.…Let's navigate to insert…and select column, 2D column.…As you can see, Excel Online has plotted the data…as a 2D column chart.…
Without actually changing anything or re-selecting the data,…select pie and then 2D pie.…As you can see, Excel Online has produced a 2D pie chart…on the same dataset.…Now let's go ahead and delete the chart.…With the data still selected, navigate to insert…and select other charts and select waterfall.…Excel Online has created a waterfall chart…where each amount is progressively added to the one prior.…Finally, let's delete the chart once more.…
- Creating and editing workbooks
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating charts
- Designing forms and surveys
Skill Level Beginner
1. Getting to Know Excel Online
2. Working Seamlessly with Excel Online and Excel Desktop
3. Collaborating with Excel Online
4. Charting in Excel Online
5. Creating Forms with Excel Online
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.