| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a Graph using function/formula to get the values?
Situation: Student database, hundreds of names and other criteria.
Project: Create graphs/charts from data Problem: can I/how do I use functions like COUNTIF to extrapolate the values for the chart with out having to count them manually? i.e. one colum has country of origin, in the worksheet I can use =COUNTIF(A2:A111,"Canadian") and get the total # of Canadians id there a way to get the chart wizard to do this? All help appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a Graph using function/formula to get the values?
You need to set up formulas in the worksheet to produce a range that is
suitable input to a chart. Alternatively you could use a pivot table to manipulate the data. Then make the chart from this data. The chart wizard is good at making charts, but it is not designed to do the math for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DivinePeitho" wrote in message ... Situation: Student database, hundreds of names and other criteria. Project: Create graphs/charts from data Problem: can I/how do I use functions like COUNTIF to extrapolate the values for the chart with out having to count them manually? i.e. one colum has country of origin, in the worksheet I can use =COUNTIF(A2:A111,"Canadian") and get the total # of Canadians id there a way to get the chart wizard to do this? All help appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a Graph using function/formula to get the valu
Thanks Jon, appreciate the info greatly.
"Jon Peltier" wrote: You need to set up formulas in the worksheet to produce a range that is suitable input to a chart. Alternatively you could use a pivot table to manipulate the data. Then make the chart from this data. The chart wizard is good at making charts, but it is not designed to do the math for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DivinePeitho" wrote in message ... Situation: Student database, hundreds of names and other criteria. Project: Create graphs/charts from data Problem: can I/how do I use functions like COUNTIF to extrapolate the values for the chart with out having to count them manually? i.e. one colum has country of origin, in the worksheet I can use =COUNTIF(A2:A111,"Canadian") and get the total # of Canadians id there a way to get the chart wizard to do this? All help appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
| create bar graph with two series and secondary y axis | Charts and Charting in Excel | |||
| Graph to create a Gant Chart | Excel Discussion (Misc queries) | |||
| How do I plot non-numeric values in a graph in Excel? | Charts and Charting in Excel | |||
| How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Linear Mode
