Nov 30 2020 07:02 PM
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.
Nov 30 2020 10:14 PM
@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:
If this doesn't answer your question, please upload an example of the chart you are working with.