Dynamic Excel Chart: Pulling Data from Two Different Tables (VBA?)

Hi All,

I'm having some trouble in trying to create a dynamic chart that pulls data from two different tables based upon the value of a combobox. So far, i've had to create each chart manually, name it, and call it via vba based on the value of a cell - this is very time consuming, as i have many charts..

I would like to know how to change the series of the created chart based upon the value of the combobox, and pull data from the appropriate table using vba. I've attached an example worksheet to give you a better understanding of my problem, and the VBA code and method i've used to date.

When posting a solution, please use comments in your code - really trying my best to learn this stuff!

Thanks everyone!

Best,
Chris

Hey thanks for the reply - ALMOST got it.

For your example, the X axis does not change.

For the "Maximum Value" chart - i'd like the x-axis to be the following: Option 1, Option 2, Option 3, Option 4, Option 5
For everything else, the x-axis should be : COA1, COA2, COA3, COA4, COA 5

Oh nevermind, just modified the code a little to reference the values...

Please Login or Register  to view this content.

Hold on, now what if i want to pull this data from a different worksheet? I thought I had that down but I guess not....I've attached another example workbook highlighting this problem (its slightly different than the one before). The code is also below.

Please Login or Register  to view this content.

I keep getting a "method range of object _global failed" error

Please disregard, problem solved - and that was the wrong code - noob move on my part