When you create a chart in Excel, it's important to make sure it stays up to date, even if you add more data later on.
Although you can manually adjust the chart's data range to include the new data, this can be tedious if you frequently update your spreadsheet.
Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table.
Watch how this formatting trick can help keep everything consistent in the video below.
Make sure you save your new changes so that your chart stays up-to-date. Not only that, but now your table has a clean, consistent format. Stay tuned to learn how to flip data on its side using the Transpose feature.