need your help with excel

Roman F
Roman F used Ask the Experts™
on
screen shooti have a table.
every day the data in the table is getting updated (by adding the row down)
the chart next to it should be fully updatable with the new row automatically
what should i do to keep the chart updated after new row
example.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Group Finance Manager
Commented:
Convert the data to a Table which will be dynamic and maybe use a PivotChart. I'll have a look at this later, just busy at the moment
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
As Roy said, you can format the data as an Excel Table and the object dependent on this table will be automatically updated.
To do that, delete the existing chart on Sheet1 --> Click inside the data --> Press Ctrl+T to format the data as an Excel Table.
Now you can insert a new chart based on this table and once you add another row in the data set, the chart will be updated accordingly.

On Sheet2, you can simple select a cell in the pivot table and insert a chart and this chart will also be dynamic in nature i.e. once you refresh the pivot table or apply filter on the pivot table, the chart will be updated accordingly.
Chart_example.xlsx
Roy CoxGroup Finance Manager

Commented:
Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial