Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

9. Create charts and graphics

In this chapter

• Create standard charts

• Create combo charts

• Create specialized charts

• Customize chart appearance

• Identify data trends

• Summarize data by using sparklines

• Illustrate processes and relationships

• Insert and manage shapes

When you enter data into an Excel worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, the price of a product, or something else entirely. What a list of values in cells can’t communicate easily, however, are the overall trends in the data. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually. In addition to standard charts, with Excel for Microsoft 365 you ...