on 05-16-2011 10:05 AM
Hello,
I have a problem with the chart run-time tools. The Focus button doesnu2019t seem to work.
Situation:
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.
Problem example:
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?
Br.
Nicolas
hi Nicolas,
I tried to replicate your scenario using Line Chart.
Sample Data
-
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.
Click Preview
Grow - 35
Off- 30
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
Off- 50
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.
Regards,
Vamsee
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.