count data in column

  • Thread starter Thread starter zchazman
  • Start date Start date
Z

zchazman

Hi, I am using excel97 and trying to create a chart that has 5 columns
of data in it a,b,c,d,e. I an trying to make a chart
only for certain data in column a and column d.

The data that I key off of is in column d and begins with s/
how can I count the number of s/ in column d?
how can I create a chart that shows both and only that data
that begins with s/ and the data in column a?
 
In cell F2 (I assume row 1 has headers) enter this formula:

=LEFT(D2,2)

and fill it down as far as you need. select any cell in the table, and
apply an autofilter (Date menu > Filter > Autofilter). Now in the
dropdown in cell F1, select s/. This only shows the rows in which the
cell in column D starts with "s/". By default Excel charts only show
visible data (change it by selecting Options from the Tools menu), so
now your chart only shows the desired rows.

- Jon
 
Back
Top