+ Reply to Thread
Results 1 to 2 of 2

How to link Droplist options with Graphs

  1. #1
    Registered User
    Join Date
    06-26-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cool How to link Droplist options with Graphs

    Hi,

    I am working on a project that people can use for documenting their actions at work.

    I would like to know how after you produce a dropdown list of options, when a person selects a choice, it will add a numerical value of '1' on a graph.

    For example:

    What is your favourite colour?

    droplist options (red, green, blue)

    [person selects red]

    -> on a graph next to it, the bar for red increases by 1, while green and blue remains at 0.

    The droplist will automatically reset after every selection, awaiting retabulation.

    ----------------

    PS. Ideally, I would have a button next to it saying "add", so after the option is chosen, the person would click on the button to add the increase on the graph.

    Thanks ahead of time,

    M

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to link Droplist options with Graphs

    You will probably need to post an example workbook as what you describe is not usual behaviour so I assume you already have code running on events.

    Basically you need to summarize the data at some point and chart those values.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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