Chart run-time tools: focus
I have a problem with the chart run-time tools. The Focus button doesnu2019t seem to work.
My chart has values (y-axis) that vary mainly from 0 to 30, but sometimes there might be values over 100. I want the user to be able to see the trend clearly between values from 0 to 30. So I have set y-axis limit to follow the max value of the spread till it reaches 30. With higher values chart max limit stays in 30 (formula in cell).
With Focus Button and Reset Scale Button I would allow user to format chart to show the overall trend with values over 30.
One of my y-values is 50. When I preview the chart the max limit is at 30 (as explained earlier). When I click Focus Chart Data-button the chart rescales to 35, but not to 50 (adds 5). Another example: my value is 80 and limit is at 60. With Focus chart data u2013button the chart rescales to 70 (adds 10) not 80
What is the logic here? Why wonu2019t the chart rescale to my value?
Vamsee Krishna Mandlem replied
I tried to replicate your scenario using Line Chart.
x1,y1 - A, 1
x2,y2 - B, 4
x3,y3 - C,15
x4,y4 - D,30
Now i bind the data with Line Chart using 'By Series' and 'Category labels'.
Go to Behavior -> scale
set Manual Y-axis
Min limit : 0
Max limit : 30
Go to 'Common' tab
Enable Run-time Tools.
Grow - 35
Auto - 35
Focus - 35
Reset - 30
Now i change my x3,y3 in excel to C, 50
Now click Preview
Properties are changed automatically as follows.
Grow - 60
Auto - 60
Focus - 60
Reset - 30
Here, i don't see any problem. As data changes, properties are automatically adjusted.
Please try it out and let me know if problem still exists.