I do have an excelfile with one sheet containing all data and several pivotcharts which are based on that "datasheet". Now I want to add some rows with new data every month and I really would like to have the charts update with the results from those newly added rows.
Do I really have to make the charts all over again and again or is it somehow possible to make the pivotcharts "interactive" in a sense that every data on the sheet is contained in the charts as well without having to make new charts?

Thanks for any info on this!