Graphing only certain columns

[Craig]

I have a sheet with some summarised data on it and a column graph of
one of the rows. I would like to have a row that has a boolean of some
kind indicating whether or not to graph that column's data and have
the graph automatically include it or not without me manually having
to edit the source data for the graph.

Can this be done without using VB? I don't mind getting into VB if I
have to but would like to just use the built-in macros if I can.

 

[ozgrid.com]

Hide the Columns you don't want graphed.

 

[Craig]

Hide the Columns you don't want graphed.

I don't want to hide the data, I want it all there. I just want the
summary chart to only include some of the columns, and having that
being able to be set by changing a field (from N to Y for example).

 

[Michael.Tarnowski]

I don't want to hide the data, I want it all there. I just want the
summary chart to only include some of the columns, and having that
being able to be set by changing a field (from N to Y for example).

Create a helper column, copy all the data (using a formula), then
chart the helper column and adjust title and legend.
Cheers Michael

 

[Craig]

Perhaps an example of what I mean.

ThingA ThingB ThingC ThingD
Graph Y N Y Y
Data 12 16 8 24

I would like to create a graph that only graphs ThingA, ThingC and
ThingD, but if I change the "Graph" data for ThingC to "N" then it
will automatically not be graphed.

 

[Craig]

Perhaps an example of what I mean.

    ThingA     ThingB     ThingC     ThingD
Graph     Y       N           Y            Y
Data      12       16         8            24

I would like to create a graph that only graphs ThingA, ThingC and
ThingD, but if I change the "Graph" data for ThingC to "N" then it
will automatically not be graphed.

Can anyone help with this?