If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Conditional FormattingEOMONTH Test | Quantum | General Discussion | 1 | July 27th, 2004 04:42 PM |