thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there!
I have a data range from A2:B20.(Column A for “Sr. No” and Column B for “Velocity”). I want to make a dynamic chart for it (the values of vertical line should hide/expand automatically).
The value of Y-axis of the chart should start from (rounddown "minimum value+10") in Column B and it should expand till the (roundup "maximum value + 10") in column B. The major tick marks value with increment of 5.
Something like in the picture given below.
[/URL][/IMG]
Any help will be highly appreciated.
I have a data range from A2:B20.(Column A for “Sr. No” and Column B for “Velocity”). I want to make a dynamic chart for it (the values of vertical line should hide/expand automatically).
The value of Y-axis of the chart should start from (rounddown "minimum value+10") in Column B and it should expand till the (roundup "maximum value + 10") in column B. The major tick marks value with increment of 5.
Something like in the picture given below.
Any help will be highly appreciated.
