cancel
Showing results for 
Search instead for 
Did you mean: 

Chart run-time tools: focus

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)