Conditional charting

I have a table of data I need to chart. For each row the data follows a
name. For example, cell B2 = John, column B3 = Joe, B4 = Joe, B5 = John
and so on randomly down the column. How can I create two charts, one
that only shows the data for John, and the other only for Joe? I don't
want to sort this data by name and I anticipate having quite a bit more
data to add below what already exists that I'd like the chart to
automatically update.

Thank you for the help!

Jason


--
jason456
------------------------------------------------------------------------
jason456's Profile: http://www.excelforum.com/member.php...o&userid=14847
View this thread: http://www.excelforum.com/showthread...hreadid=265125

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

and conditional charts:

http://www.peltiertech.com/Excel/Cha...html#CondChart

You could combine those techniques and create one chart from each
person's data.

jason456 wrote:
I have a table of data I need to chart. For each row the data follows a
name. For example, cell B2 = John, column B3 = Joe, B4 = Joe, B5 = John
and so on randomly down the column. How can I create two charts, one
that only shows the data for John, and the other only for Joe? I don't
want to sort this data by name and I anticipate having quite a bit more
data to add below what already exists that I'd like the chart to
automatically update.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I don't know if my conditional chart approach is the best here. What I would do is
make a chart with all the data, then use an autofilter on the table to show either
Joe's or John's data. By default, a chart only shows the visible data, so make Joe's
visible, then paste a picture of the chart somewhere, then repeat with John's data.

Depending on the rest of the data, you might be able to split it out with a pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Debra Dalgleish wrote:

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

and conditional charts:

http://www.peltiertech.com/Excel/Cha...html#CondChart

You could combine those techniques and create one chart from each
person's data.

jason456 wrote:

I have a table of data I need to chart. For each row the data follows a
name. For example, cell B2 = John, column B3 = Joe, B4 = Joe, B5 = John
and so on randomly down the column. How can I create two charts, one
that only shows the data for John, and the other only for Joe? I don't
want to sort this data by name and I anticipate having quite a bit more
data to add below what already exists that I'd like the chart to
automatically update.