Command buttons to change Values in Charts

[RoboRaz]

Hi,

I would like to know how I could use an active x command button to change the values in a chart (Bar chart, doughnut charts, line graphs etc.)

What I wish to do is that if a user presses Command Button 'A' then the values in charts change according to Table 'A' and when they press Command Button 'B' then the values in charts change according to Table 'B'.

[ptmuldoon]

Are the 2 tables the same except for the data in them? Say headings, etc?

If you post a small sample file, I can take a look at it. Essentially you want a button to change the source data of the chart. A quick google search found this code which you can adapt.

Please Login or Register  to view this content.

[RoboRaz]

Hey thanks for the reply. Yes the two tables are the same

[RoboRaz]

Here is a screen shot of what I'm doing. I wasn't sure how I could post an excel file

MPSZPJX.png

[DarkF1ame]

@RoboRaz

Here is a super simple workbook I made by googling around and compiling some different bits of code out there plus a new function.

Let me know if it helps.

Thanks,

DarkF1ame

[RoboRaz]

Are the 2 tables the same except for the data in them? Say headings, etc?

If you post a small sample file, I can take a look at it. Essentially you want a button to change the source data of the chart. A quick google search found this code which you can adapt.

Please Login or Register  to view this content.

Hey man thanks it's starting to work. I had to change the code a bit for it to work for me:

Dim CHARTDATA As Range
Set CHARTDATA = Range(Range("AO42"), Range("AO42").Offset(0, 1).End(xlDown))
ActiveSheet.ChartObjects("Chart 1").Chart.SetSourceData Source:=CHARTDATA

Would you please break down the code so I could get the story behind it? I don't quite understand this Range as just "C22". What if I want to limit the number of rows in my table, how would I do that? For example, if I have the Total (Sum) at the bottom of the table but I don't want to show it in my chart, then how would I go about it?

Also does this mean that I'll have to have a table in separate columns (one beside the other)? I mean to say that it can't have tables one beneath the other? If I have two command buttons, one for each table which would change the values in the bar chart.