+ Reply to Thread
Results 1 to 2 of 2

Options Button that Changes Multiple Charts?

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Options Button that Changes Multiple Charts?

    I am using an options control button to switch between showing the data from three scenarios on a chart.

    Right now when you click "Scenario 1" the data for Scenario 1 appears on the chart.

    What I am wondering is if it is possible to link the Option button to two charts.

    The chart it is synced to at the moment is to show Total Gross Profit Estimations, but I would also like for the user to be able to see another chart showing the ROCE values for the same scenario.

    So: User clicks "Scenario 1" and Chart 1 and Chart 2 both update with Scenario 1's data. When the user clicks "Scenario 2", the data on each chart switches to Scenario 2's data.

    Is this a possibility? Any help is greatly appreciated. Thank you

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,881

    Re: Options Button that Changes Multiple Charts?

    It is certainly possible, and I helped someone else with a very similar question. But the answer will be very specific to your file. Please attach your file, and describe where the option buttons and charts are that you are talking about.

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Charts with Options Button
    By TUFXP in forum Excel General
    Replies: 1
    Last Post: 12-13-2015, 08:06 PM
  2. Four charts one worksheet need to print charts by button
    By dan2014 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2015, 06:13 AM
  3. Replies: 0
    Last Post: 08-26-2014, 08:44 AM
  4. [SOLVED] Linking together an Options Button and a command button inorder to load separate forms
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 02:10 PM
  5. charts/graphs for stock options
    By amartino44 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2013, 01:23 PM
  6. Can I import a new colour into the options for creating charts?
    By Lyn37 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-08-2005, 02:05 PM
  7. More options for Area charts - suggestion to MS
    By Jerry W. Lewis in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-05-2005, 12:06 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