Hi Expert,
Is there any way that graph range may extend automatically based on new line, like when Apr sales available, graph range should be A2:B5 ? instead of A2:B4. or any other solution.
I don't want Apr without sale in Graph
Is there any way that graph range may extend automatically based on new line, like when Apr sales available, graph range should be A2:B5 ? instead of A2:B4. or any other solution.
I don't want Apr without sale in Graph
Book4 | ||||
---|---|---|---|---|
A | B | |||
1 | Month | Sales | ||
2 | JAN | 200 | ||
3 | FEB | 250 | ||
4 | MAR | 150 | ||
5 | ||||
Sheet1 |