Concept Map

Concept Map

Maia Dominguez Martinez

Adding Alternative Text (Alt Text) to a Chart

Creating a Basic Chart

Microsoft Excel

A chart is a pictorial representation of data in a worksheet that can help you identify trends/patterns

Add Alternative Text

Lesson 6: Working with Charts

Moving and Resizing Charts

Changing Chart Types

Charts can be moved to any location on the worksheet or to another worksheet

Creating Chart Sheets

Working with Pie Charts

By default, Excel places a chart in the same worksheet where the source data is located

Using the Quick Analysis Tool

By default, Excel places a chart in the same worksheet where the source data is located

By default, Excel places a chart in the same worksheet where the source data is located • You can move this chart: – to its own chart sheet – back to its original worksheet – to a different worksheet

Using the Quick Analysis Tool

Displays in the bottom right corner each time a range of cells is selected • Click the button to display the options:

Enlace

Adding Alternative Text (Alt Text) to a Chart

Add Alternative Text (alt text) to aid the visually impaired to understand what the purpose of your chart or object is

Working with Pie Charts

Commonly used to show relative sizes or percentages of each piece of a total • Only one data series can be charted • Portions of pie chart can be exploded or moved away from the chart

Moving and Resizing Charts

Charts can be moved to any location on the worksheet or to another worksheet • Charts can be resized – Click and drag any of eight handles at mid-points or corners

Creating a Basic Chart

A chart is a pictorial representation of data in a worksheet that can help you identify trends/patterns – You can use various chart types depending on how you want to show your data – You can choose styles within each chart type to emphasize data • To insert a chart: – Select the data you want to show in the chart – On the Insert tab, in the Charts group, click a chart type, and then click an option

Changing Chart Types

– Column – Line – Pie – Bar – Area – XY (Scatter) – Map – Stock – Surface