| 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. |
| 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 | |||
Threaded Mode
