Working with Charts

Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.

Chart tools

Once you insert a chart, a new set of Chart Tools, arranged into three tabs, will appear above the Ribbon. These are only visible when the chart is selected.

Select Data for Chart

To change the chart type:

Change Chart Type

The chart in the example compares each salesperson's monthly sales to his or her other months' sales; however, you can change what is being compared. Just click the Switch Row/Column Data command, which will rotate the data displayed on the x and y axes. To return to the original view, click the Switch Row/Column command again.

To change chart layout:

Change Chart Layout

If your new layout includes chart titles, axes, or legend labels, just insert your cursor into the text and begin typing to add your own text.