Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating of a chart? | Charts and Charting in Excel | |||
Chart - conditional format | Charts and Charting in Excel | |||
Can I conditional format a chart? | Charts and Charting in Excel | |||
Conditional chart | Charts and Charting in Excel | |||
Conditional formatting a bar chart | Charts and Charting in Excel |