TomakeyourdataDynamic, youcanuse
Answers
Answered by
0
The dynamic formula method
- Click the Formulas tab.
- Click the Define Names option in the Defined Names group.
- Enter a name for the dynamic range, MonthLabels.
- Choose the current sheet. In this case, that's DynamicChart1. ...
- Enter the following formula: =OFFSET(DynamicChart1!$ A$2,0,0,COUNTA(DynamicChart1!$ ...
- Click OK.
Similar questions