Conditional Chart
 

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?

Conditional Chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"excelBRISKbaby" wrote in message
...
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?