Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 30th, 2011, 03:57 AM
Friend of Wrox
Join Date: Jan 2011
Posts: 103
Thanks: 7
Thanked 0 Times in 0 Posts
Default Linking dropdown boxes and charts using forumlas


Does anyone know how to create a graph which is linked to a drop down box In Excel 2010?

I am trying to create a really complicated workbook (which proabbly doesn't need to be that complicated but oh well) which has 3 data sheets and one graph sheet. On the graph there are 9 charts and 2 drop down boxes.

One of the drop down list needs to state which data sheet to look for the data and then the other drop down box needs to state which column to look for the data in.

Each data sheet is split into 2 sections current and previous and then the each sections are split into 9 sets. The charts on the graph page are linked to the 9 sets on each data sheet.

The charts have 2 variables one for current and one for previous.

However i need to llink the dropdown boxes to the charts so that if the dropdown box variables are changed it will show the correct data in the data sheets.

For example, if the sheet dropdown box is changed then the charts will refresh with data from the correct sheet and hsowing the data for the column which is shown in the column drop down box.

The annoying fact is i cant use VBA(not sure if this is right forum to come on but i am desperate), does anyone know how to do this using forumlas instead of VBA?



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Access Charts Using Combo Boxes ThumbCast Access 2 April 7th, 2005 08:47 AM
Page Linking though DropDown Lists mahulda ASP.NET 1.0 and 1.1 Basics 2 April 23rd, 2004 02:58 PM
Dynamic Menu - Using multiple dropdown boxes Sebastiaan Javascript How-To 2 December 1st, 2003 05:36 AM
dynamic dropdown boxes fmh002 Classic ASP Basics 1 June 26th, 2003 08:35 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.