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.
@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.