live update chart data

Copper Contributor

How can I make a chart redraw as I add more rows of data into a sheet.

 

I tried to use an entire column (eg $A:$A) for 'Y values' source data, but Excel for Mac just hangs with a spinning beachball. It only allows me to use a fixed range.

1 Reply

@mountainmanjoe If you build your chart based on a structured table, the chart will expand automatically as you add more rows to the table. See attached file for a working example.

 

More about tables, here:

https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e... 

 

If this doesn't answer your question, please upload an example of the chart you are working with.