Skip to content

How to Create Expandable Charts in Excel

In this article, you will learn how to create expandable charts in Microsoft Excel.

Now what do I mean by expandable?

I consider a chart to be expandable if you can easily add data to the chart without having to re-select that data.

For example, let’s say you have a chart showing the numbers for some sales agents.

If this chart were expandable, you could simply type in the info for a new sales agent, and that data would immediately show up on the chart like so.

Non-Expandable Charts

If you create a chart in Excel by referencing a normal data range, then that chart will be non-expandable.

If you want to add new data to the chart, you would have to right-click on the chart, choose Select Data, and then edit the data series to include the new information.

This can be a very tedious process, especially if you add new data often. However, turning your standard chart into an expandable chart is not that difficult.

How to Create an Expandable Chart

To make your chart expandable, all you have to do is turn the referenced data range into an Excel Table. You can do this by selecting the data and using the keyboard shortcut CTRL + T.

Once you do, you can simply expand the table to add new data. And all new data added to the table will automatically appear in your chart.

Now you don’t have to go through the tedious process of re-selecting the chart data. The graph will update automatically to include any information added to the table.

The Big Takeaway

So the moral of the story is actually pretty simple.

If you set up your chart to reference data in an Excel table rather than a normal cell range, you can add new data to the chart much more easily.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top