Because there's more than one way to skin a cat, I'll propose an
alternative. Insert a row at the top, and put 'Colors' into cell A1.
Make a pivot table with this data range, putting Colors into the Row
Fields area and also Count of Colors into the Data Area. You get a
table that looks like this:
Count of Colors
Colors Total
blue 2
red 2
white 1
Grand Total 5
You can click and drag the cells containing the labels blue, red, and
white up and down to change the order that they appear, resulting in this:
Count of Colors
Colors Total
red 2
white 1
blue 2
Grand Total 5
Pivot tables are overkill for this example, but for more complicated
data and analyses, they are awesome.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
MikeC said:
Given a column with text in cells like the following:
(a1)red
(a2)white
(a3)blue
(a4)red
(a5)blue
how do I create a column chart that will show the first
column with 2 reds, the 2nd column with 1 white, and the
3rd column with 2 blues? Do I have to format the cells
uniquely?
Try this:
(b1) red
(b2) white
(b3) blue
(c1) =COUNTIF(A:A,B1)
[fill down to c2 and c3]
Now plot the results of column C.
Dave
dvt at psu dot edu
