Is there a way to update specific data in a Line Graph ? I have data in a Pivot table that is shown in a line graph per week. Is there a way I can have the Line graph only update to show past weeks to current week data. Sometimes there may be data available for the following week as it is entered but I don't want the line graph to show future weeks just past to current.
I should mention that in the workbook I have created I have
160 + Line Graphs
57 Worksheets with over 160 + total pivot tables.
Thank you for your help, please remember that I am very new to VBA and any code that you give will needed to be explained in simple terms.
Thanks again.
I should mention that in the workbook I have created I have
160 + Line Graphs
57 Worksheets with over 160 + total pivot tables.
Thank you for your help, please remember that I am very new to VBA and any code that you give will needed to be explained in simple terms.
Thanks again.
