• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Maximum Slider Value for Scatter Graph

T

Tripp

Member
Hello,

I have a very large data set, some 97,000 lines, and I wanted to create a nice looking slider to highlight the points along the scatter graph. The issue I have is that the maximum allowed value for the slider is 30,000 so I can only use my slider for about a third of the graph, which I have done and it works for that third.

I have played around with setting but cant seem to figure out a good solution. It may be that its limited as more than 30,000 would significantly reduce the performance of the slide perhaps? If that's the case I will just put certain values on the graph and leave it at that.

Regards,

Tripp
 
I'm guessing that it's a 'forms' scrollbar your talking about.
It has a linked cell which you're using the value of to highlight the points?
If you then take another cell where you multiply the values in the linked cell by 4 you'll have a range of values from 0 to 120,000, in jumps of 4. Can you use that cell instead? I don't think humans have the eyesight to resolve 1 among 90,000 points on a chart.

Supply a file and it would take a lot of the guesswork out.
 
Hi p45cal,

Your guess is correct, it is a forms scrollbar and I'm using a linked cell to highlight the values, apologies for not being clearer. I tried applying your suggestion but when I try to apply a formula to the linked cell it is immediately removed and simply becomes the current value between 1 and 30000.

I am also using large increments in the scrollbar as you are right that the human eye could not distinguish such small increments plus it would run very slowly.

The work is confidential hence I cannot post the file, but thank you for the suggestion and if anything else is unclear please say.

Regards,
Tripp
 
'take another cell where you multiply the values in the linked cell by 4'
Not the linked cell itself!
Then whatever used to use the linked cell value, point it to this other cell instead of the linked cell.
 
Ah Sorry!!

As you said, I've changed the parameters in my offset functions for the scrollbar (x4) and its worked beautifully.

Thanks a lot
 
You must log in or register to reply here.
Back
Top