Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.
Once you insert a chart, a set of chart tools arranged into three tabs will appear on the Ribbon. These are only visible when the chart is selected. You can use these three tabs to modify your chart.
Sometimes when you create a chart, the data may not be grouped the way you want. In the clustered column chart below, the Book Sales statistics are grouped by Fiction and Non-Fiction, with a column for each year. However, you can also switch the row and column data so the chart will group the statistics by year, with columns for Fiction and Non-Fiction. In both cases, the chart contains the same data—it's just organized differently.
Some layouts include chart titles, axes, or legend labels. To change them, place the insertion point in the text and begin typing.