Help: Show series on graph if checkbox ticked 1

[Walshie1987]

Hi, I have a graph with various pieces of data on it (Series 1, Series 2 etc)

I want to have check boxes next to the graph so when I tick them the data is visible on the graph and when I untick them I want the data on the graph not to be visible.

I don't want to use:

column(x).hidden = false

Any other ways around this?

Cheers
Chris

 

[SkipVought]

Hi,

The simpliest way is to FIRST, make sure that the Chart Options include Plot visible cells only

You may or not be able to use the AutoFilter, depending how you data is organized

Use the control to control hiding/unhiding the appropriate row or column. Use the macro recorder if necessary.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[combo]

Depending on the data structure, pivot chart can be useful.

combo

 

[Walshie1987]

Thanks for the above, will play around and see what I can do!

Chris

 

[electricpete]

Here is an example that does what you want.

http://home.comcast.net/~electricpete/eng-tips/CheckCurvesOnOff.xls

The checkbox is tied to a cell.

The cell holds a boolean.

The boolean is used in a named formula. The named formula returns either the range you want (if checkbox cell is true) or a blank range (if checkbox cell is false).

The named formula is inserted into the chart value series.

Try it. Let me know if questions.

 

[electricpete]

To be a little more complete, I should have used a calculated named formula for the series names, so they would also go away when the checkbox was unchecked.

 

[Walshie1987]

Hi Pete, Thats exactly what I'm looking for, Thanks thats a huge help!

Cheers
Chris