Conditional charting

  • Thread starter Thread starter jason456
  • Start date Start date
J

jason456

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

Thank you for the help!

Jaso
 
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/
_______
 
Back
Top