Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.
There are many other ways to customize and organize your charts. For example, Excel allows you to rearrange a chart's data, change the chart type, and even move the chart to a different location in the workbook.
Sometimes you may want to change the way charts group your data. For example, in the chart below, the Book Sales data are grouped by year, with columns for each genre. However, we could switch the rows and columns so the chart will group the data by genre, with columns for each year. In both cases, the chart contains the same data—it's just organized differently.
If you find that your data isn't well suited to a certain chart, it's easy to switch to a new chart type. In our example, we'll change our chart from a Column chart to a Line chart.
Whenever you insert a new chart, it will appear as an object on the same worksheet that contains its source data. Alternatively, you can move the chart to a new worksheet to help keep your data organized.
By default, when you add more data to your spreadsheet, the chart may not include the new data. To fix this, you can adjust the data range. Simply click the chart, and it will highlight the data range in your spreadsheet. You can then click and drag the handle in the lower-right corner to change the data range.
If you frequently add more data to your spreadsheet, it may become tedious to update the data range. Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date.
Watch the video below to learn how to use tables to keep charts up to date.