Lesson 6: Working with charts

Lesson 6: Working with charts

1. Create charts

   • What is it?
     • Pictorial representation of data
   • How?
     • Select the data, Insert tab, Charts group, and then in the chart

2. Add alt text to a chart

   • What is it?
     • Aid the visually impaired to understand the purpose of your chart
   • How?
     • Right-click the chart, click Edit Alt Text, then enter a brief description of the chart

3. Move and resize charts

   • What is it?
     • Charts can be moved to any location on the worksheet
   • How?
     • Click and drag any of eight handles at mid-points or corners

4. Create chart sheets

   • What is it?
     • Excel places a chart in the same worksheet of the source data
   • How?
     • Click Insert, select chart, select which kind of chart you want

5. Change the chart type

   • What is it?
     • When you already have a chart in excel but you don’t like the result, you can change it to another type
   • How?
     • You have to select the chart and click on “change chart type” on the design tab of the ribbon

6. Work with pie charts

   • What is it?
     • If you have a chart we’re you can know how much money can you spend, you can make a pie chart
   • How?
     • Select the part of the chart, go to design or insert and the look for the button that say charts, and look for the pie chart

7. Change the chart design

   • What is it?
     • You can change the chart that you have if doesn't helps you
   • How?
     • Click in the chart, look for the chart design and chose the one you need

8. Add new data to a chart

   • What is it?
     • It's the data that your chart have
   • How?
     • Right-click the chart, click Select data, in the dialog box make the corrections or add the info you need

9. Create, customize, and remove a sparkline chart

   • What is it?
     • Tiny chart in a worksheet cell that provides a visual representation of data
   • How?
     • Select a blank cell at the end of a row of data, select insert and pick sparkline type, select cells in the row

10. Print a chart

    • What is it?
      • Directs production reporting to output a chart according to the named chart
    • How?
      • Click the chart and in the file section choose the print option, and select the printer

11. Use the Quick Analysis tool

    • What is it?
      • Helps you quickly format your data into a chart, table, summary formula, sparkline, or highlighted figures
    • How?
      • Select the range of cells, select the quick analysis tool button, select charts, and place the cursor on the type of charts