mae0429
06-30-2008, 12:35 PM
Hi all,
I've got some data that when all is said and done, it consists of 6 groups of 6 ranges (with variability in the number of cells in those ranges). Currently, I'm displaying them as 36 separate charts on the same worksheet. Is it possible to add 6 checkboxes to a chart that would allow for selection of a range to make a series? This way, I could narrow this to 6 charts, making it a little more useful to my end user.
I started on it some, but obviously I cannot refer to the chart with the object "Frame1" because it won't support that property. Any ideas how to go about this? (I don't want the whole "user form w/ picture" solution, please)
Here's what I've tried (with all the necessary declarations):
Set Frame1 = Worksheets(activeShtName).ChartObjects(a)
For idx = 1 To 6
Set chk = Frame1.Controls.Add("Forms.CheckBox.1", "CheckBox" & idx, True)
chk.Left = 5
chk.Top = (idx - 1) * (chk.Height + 2)
chk.Caption = "CheckBox " & idx
Next idx
Thanks!
-Matt
I've got some data that when all is said and done, it consists of 6 groups of 6 ranges (with variability in the number of cells in those ranges). Currently, I'm displaying them as 36 separate charts on the same worksheet. Is it possible to add 6 checkboxes to a chart that would allow for selection of a range to make a series? This way, I could narrow this to 6 charts, making it a little more useful to my end user.
I started on it some, but obviously I cannot refer to the chart with the object "Frame1" because it won't support that property. Any ideas how to go about this? (I don't want the whole "user form w/ picture" solution, please)
Here's what I've tried (with all the necessary declarations):
Set Frame1 = Worksheets(activeShtName).ChartObjects(a)
For idx = 1 To 6
Set chk = Frame1.Controls.Add("Forms.CheckBox.1", "CheckBox" & idx, True)
chk.Left = 5
chk.Top = (idx - 1) * (chk.Height + 2)
chk.Caption = "CheckBox " & idx
Next idx
Thanks!
-Matt