Conditional Chart

[Guest]

Hello,

I have a set of data that has many factors associated with it. I would like
to setup some dynamic charts to be able to report, automatically, the values
based on certain conditions.

For example, my rows are composed of sets of data (Title 1, Title 2, Title
3) while my columns are composed of data and conditions. For example, Value,
Group, etc..
Value Group Color
Title1 2 1 Blue
Title2 4 2 Blue
Title3 1 1 Red

I want the first chart to plot only those from group 1, I want the second
chart to plot those only that have the blue color. Is there anyway to do this?

 

[Jon Peltier]

You need to use a pivot table, a filter, or array formulas to extract the
data for each chart. The charting itself should then be easy.

- Jon