Re: Create a Pie Chart?
Tech-Archive recommends: Speed Up your PC by fixing your registry
I think the easiest way to get what you want is by using countif
Let's say that your city names are in the D column,
use some blank cells to hold this formula
=COUNTIF(D:D,"New York")
=COUNTIF(D:D,"Los Angeles")
etc.
now create a pie chart with these cells as the data series. I think
this is what you are looking for.
.
Relevant Pages
- Re: Which function to use?
... If the result of this countif calculation yielded an answer which is greater ... then obviously the whole column has one or more cells in it ... Harald used the MAX and MIN functions to achieve a similar outcome. ... You mentioned that values for one city could be positive, ...
(microsoft.public.excel.worksheet.functions) - Re: How do I include an attachment to mail merged email?
... The code in the macro does rely on the catalog merge producing a table, ... to be in the cells of a table. ... So for a record that has Houston as the city, ... If there was no entry in the city field, ...
(microsoft.public.word.mailmerge.fields) - Re: How do I include an attachment to mail merged email?
... > to be in the cells of a table. ... > So for a record that has Houston as the city, ... > If there was no entry in the city field, ... > Doug Robbins - Word MVP ...
(microsoft.public.word.mailmerge.fields) - Re: Mix/Max/Avg Help based on dynamic ranges
... I would recommend that you split those into separate cells. ... Where Nums are the values to avg based on the head count range. ... deemed optimal for building device profiles based on locn size and device ... sumif function and dividing by the results of the countif formula... ...
(microsoft.public.excel.worksheet.functions) - Re: Help w/ Formula!
... I had to change the COUNT part to COUNTIF ... "Dave Peterson" wrote: ... Bob Phillips explains =sumproduct() in much more detail here: ... will return the number on non-empty cells in that range. ...
(microsoft.public.excel.misc) |
|
