Interesting visualization idea

[Ferloft]

So here is my idea, just wondering if it is possible.

So say cell B1 has a value of 10. Now my idea is for cell B2 to have a marker that shows where the value of B1 falls on a scale.

For instance:
Capture.JPG
(just so you can understand what im getting at)

If this is at all possible I could apply it to a project I am currently working on. If not, it was a good idea

[ragulduy]

Dont see why you couldn't do that. Draw the shape/use a picture and then move it as neccessary. The minimum value would be:

Please Login or Register  to view this content.

and the maximum value would be

Please Login or Register  to view this content.

so the position of the centre of the slider would be

Please Login or Register  to view this content.

I guess you would need to subtract half of the slider width and then assign that formula to the slider.left property (where slider is a variable assigned to your shape/picture)

[Ferloft]

What would the code be to assign slider to the shape?

[ragulduy]

Please Login or Register  to view this content.

or you could use:

Please Login or Register  to view this content.

instead

[Ferloft]

I have this

Please Login or Register  to view this content.

but I get the error "Object doesn't support this property or method"

Sorry if I'm slow, never used excel shapes before

[ragulduy]

You need

Please Login or Register  to view this content.

[Norie]

Try this, which goes in the worksheet module, which can be accessed by right clicking the worksheet tab and selecting View Code.

Please Login or Register  to view this content.

It's only set up for B1/B2 but could be adapted if you have a row of these shapes as in the image.

[Andy Pope]

non coded approach.

would need more work if the min/max values change radically

[Ferloft]

Here is what I have come up with:

Please Login or Register  to view this content.

It is set to automatically run when G3 is selected. E5 and G5 are the min and max.

Another cool idea would be to create a color gradient that changes the slider depending on position. I think this would be similar to finding the position but it seems a bit daunting for me.