202R1/2 Charts with Spreadsheets

 |  No Comments

Excel workbooks often contain a lot of data, spread over many columns and rows. This makes it hard to interpret the information into something useful

Using Charts lets you illustrate your workbook data graphically, which makes it easy to identify comparisons and trends.

VIDEODOWNLOADS

https://youtu.be/_Wu7jYTr1Pk

 

  • https://youtu.be/_Wu7jYTr1Pk
  • 0:00 Intro to chart types in Excel
    0:08 Column charts overview
    0:28 Line charts for trends over time
    0:32 Pie charts for proportions
    0:38 Bar and area charts explained
    0:52 Example data set and inserting a chart
    1:20 Creating a column chart
    1:30 Using the legend
    1:45 Switch Row/Column feature
    2:06 Changing chart type
    2:21 Line chart insight
    2:42 Changing chart style
    2:48 Editing chart layout and elements
    3:18 Add/remove chart elements
    3:35 Editing chart title
    3:49 Move chart to another sheet
    4:13 Charts recap and value in Excel

  1. Worksheet
  2. Practice Spreadsheet

You need to be logged in to view the rest of the content. Please . Not a Member? Join Us

Share this by:

Share on SMS Share on WhatsApp Share on LinkedIn
Tags: , ,