live update chart data

%3CLINGO-SUB%20id%3D%22lingo-sub-1943121%22%20slang%3D%22en-US%22%3Elive%20update%20chart%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943121%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20make%20a%20chart%20redraw%20as%20I%20add%20more%20rows%20of%20data%20into%20a%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20an%20entire%20column%20(eg%20%24A%3A%24A)%20for%20'Y%20values'%20source%20data%2C%20but%20Excel%20for%20Mac%20just%20hangs%20with%20a%20spinning%20beachball.%20It%20only%20allows%20me%20to%20use%20a%20fixed%20range.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1943121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943289%22%20slang%3D%22en-US%22%3ERe%3A%20live%20update%20chart%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F886453%22%20target%3D%22_blank%22%3E%40mountainmanjoe%3C%2FA%3E%26nbsp%3BIf%20you%20build%20your%20chart%20based%20on%20a%20structured%20table%2C%20the%20chart%20will%20expand%20automatically%20as%20you%20add%20more%20rows%20to%20the%20table.%20See%20attached%20file%20for%20a%20working%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20about%20tables%2C%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Foverview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Foverview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20doesn't%20answer%20your%20question%2C%20please%20upload%20an%20example%20of%20the%20chart%20you%20are%20working%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.