+ Reply to Thread
Results 1 to 10 of 10

Displaying dynamic photo and graph with slider

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    5

    Displaying dynamic photo and graph with slider

    Hi guys.

    I've created a sheet with a slider. Whenever user selects a value, I want to be able to update picture and a graph accordingly to whatever he selected on slider (see document attached), and values in Data tab that corresponds to selected value.
    In the Name Manager I've created Slider value, which corresponds to selected value on vertical slider, Photo which correspond to photo I want to use and GraphDisp with the value I want to display on graph.

    I have a tab called Photo, where I store 2 photos, and I have a tab called Data, where I have indexes of photos to display (1,1,1,1,1,2,2,2,2,2) and data (1,2,3,4,5,6,7,8,9,10). Whenever user selects a new value, I want to have an Offset from A1 and B1, and display photo with index from column A, and data from column B. So if user select value 4, I want to display photo with index 1 and value 4 on graph. If he selects 5, I want photo with index 2, and value 5 etc.

    The problem is that whenever I move slider values with arrows, photo updates depending if I'm clicking Up, or Down. It supposed to change between 4 and 5, but it changes between 3 and 4 or between 5 and 6.

    This is happening because data are also updating on the graph, if I delete the graph it works fine again. If I go from 4 to 5, graph updates, but photo doesn't, then when I click F9 (Calculate now), the photo updates correctly.

    How can I fix it, if I want to display graph too? I was trying Calculating options, but either graph doesn't update anymore, or it doesn't change anything.

    Thanks

    PS. This was working correctly on Office 2010, you have to have 2013 to see the issue
    Attached Files Attached Files
    Last edited by siadajpan; 02-20-2017 at 08:33 AM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Displaying dynamic photo and graph with slider

    Refer attach file.
    In this file i have from tab inseart picture and in name manager using index match formula with main sheet slider.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    5

    Re: Displaying dynamic photo and graph with slider

    Hi

    Your solution works the same as mine...
    If you go from 0-9, photo is changing 5->6
    and if 9-0 it's changing 4->3.

    I bet you test it before sending, so is there something you've selected on your excel that I don't have selected on mine?

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Displaying dynamic photo and graph with slider

    I have tested & its work perfectly. from 0 to 4 first photo & 5 to 9 second photo.
    Even if reverce 9 to 5 second photo and 4 to 0 first.
    If you need changes in number kindly go to sheet "photo and change accordingly.

  5. #5
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    5

    Re: Displaying dynamic photo and graph with slider

    Hi

    I've created a gif to proove it:
    slider problem

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Displaying dynamic photo and graph with slider

    I am using 2007. And we try n number of but result is ok at our end. Result as per photo sheet. Refer "A1:A4" First Photo & "A5:A10" second photo. As per your gif i have check but photo shows as per number only. 0-9 / 9-0/ 2-8/ 8-2/ 3-8/8-3 with all respect i have check but its ok.

  7. #7
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    5

    Re: Displaying dynamic photo and graph with slider

    Hi

    Thank you for your time
    I didn't change anything in the document you've sent. I just opened it and run.

    There are 2 things that maybe are different from your use than mine:
    1. I was using arrows on slider to go through the images. If I change the number that slider is linked to, pictures are changing correctly. The thing is, that I have to use slider to change images.
    2. I am using Excel 2013, and it is an Excel bug...

    Can you please test again by using slider arrows?

    I need some help with this.

    Thank you

  8. #8
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Displaying dynamic photo and graph with slider

    Hellow,
    I changed numbering in "format control" as well as photo sheet.
    Earlier in "format control" min value is 0 & in photo sheet min value is 1. Now both match 0 to 10.
    Attach revised file plz see and confirm.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    5

    Re: Displaying dynamic photo and graph with slider

    Hi

    Unfortunately, it didn't change anything.

    I found that workaround is to use additional Active X slider.
    If I have only one slider (doesn't matter which one), and I click on slider arrows 1 to 9, picture is changing when clicking 5->6 (too late)
    However, when I've added Active X slider linked to the same cell as normal slider, after clicking on Active X slider, the other slider updates and the picture changes 4->5 (correct!)

    When I delete one of the sliders, problem occurs again...

    For now I will just put one slider below another, and use it as a workaround.

    I still don't know why the problem occurs in Office 2013, I guess it has to be a bug with picture update

  10. #10
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Displaying dynamic photo and graph with slider

    I tried all of ways. Nothing incorrect in 2007. It may be due some tech difference between 2007 & 2013 version.
    Anyway wish you all the best for future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I want the photo to be empty when there is no photo for the employee(Userform)
    By leprince2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2016, 12:19 PM
  2. Replies: 0
    Last Post: 10-16-2016, 10:48 PM
  3. Replies: 3
    Last Post: 08-06-2015, 05:47 PM
  4. Not Graph Zeros, Divs or N/As- Photo included.
    By ghladik in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2013, 10:22 AM
  5. Dynamic link Access to Excel with photo
    By burna in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-22-2007, 08:59 PM
  6. Dynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake@yahoo.com in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-02-2006, 04:10 PM
  7. Replies: 6
    Last Post: 01-25-2006, 02:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1