+ Reply to Thread
Results 1 to 2 of 2

VBA code to change a chart based on a selection from a listbox on a form

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Erlanger, KY
    MS-Off Ver
    2010
    Posts
    81

    VBA code to change a chart based on a selection from a listbox on a form

    Currently I have VBA code that changes Pivot charts based on a selection from a list box on a form. I need it to change the code to effect regular charts. The pivot chart is not giving them what they want.

    Is this something that can be done?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: VBA code to change a chart based on a selection from a listbox on a form

    Generally speaking, dynamic charting is accomplished by using named dynamic ranges. Without seeing the layout of the data, I can't say more.

    Here are two articles related to dynamic charting. The first explains how to make a named dynamic range and the second explains how to use them in charts.
    http://www.utteraccess.com/wiki/inde...Dynamic_Ranges
    http://www.utteraccess.com/wiki/inde...namic_Charting
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Creating a Range of a Listbox based on the Selection Made in Another ListBox
    By masood78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2014, 11:03 AM
  2. How to change selection in two listboxes by changing selection in a third listbox
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2013, 02:39 PM
  3. Replies: 12
    Last Post: 08-28-2012, 07:09 AM
  4. [SOLVED] Multi Column Listbox change based on a selection from a combobox
    By AttalaEA in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-21-2012, 06:00 AM
  5. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  6. How do I get value of a multi-selection form listbox?
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-15-2010, 03:57 AM
  7. populate listbox based on selection in previous listbox
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2007, 10:55 PM

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