Illustrated Excel 2019 Module 4: Textbook Project India Nicolas 1) Create a Chart Insert a chart

Illustrated Excel 2019 Module 4: Textbook Project

India Nicolas

1) Create a Chart

Insert a chart.

2. Move and Resize a Chart

Move a chart to a chart sheet.

Enter text in a cell.

3. Change the Chart Design

Enter a number in a cell.

Change the chart colors.

Change the chart style.

4. Change the Chart Layout

Add a vertical axis title to a chart.

Change the font size of horizontal axis text.

Add a border to a chart element.

Change the type of data table displayed in a chart.

Remove a legend from a chart.

5. Format a Chart

Change the fill color of a data series.

6. Create a Pie Chart

Insert a chart.

Move a chart to a chart sheet.

Change the fill color of the chart title.

Explode a data point in a chart.

7. Summarize Data with Sparklines

Add sparklines to a cell.

Set the color of a sparkline.

Format sparklines.

Format sparklines.

Enter a number in a cell.

8. Identify Data Trends

Add a trendline to a chart.

Change the position of the legend.