M
Mike
Hi, I need to create a chart using Excel 2003 and or PowerPoint 2003. The
nonnumeric data is
stored in a multiple column spreadsheet. In one of the columns (A) the
cells are populated with letters (BT or PP or RD) I need a dynamic total of
the number of populated cells (not all cells are populated) in this column,
then I'd like to compare the total number of entries to another column (B)
that is populated w/ Xs, Rs and Ns. These letters refer to the status of
the PKI certificates i.e., received, requested or needed. So, I'd like
these values to be a dynamic chart that'll update every time a value is
added or changed. What I'm doing is rolling out PKI installations where
column A is location of the PKI installs and column B is status of PKI
certificates issued to users. I'm also collecting other user information
but is not relevant to this chart. Eventually, I'll convert the spreadsheet
to an access database.
Thanks,
Mike
nonnumeric data is
stored in a multiple column spreadsheet. In one of the columns (A) the
cells are populated with letters (BT or PP or RD) I need a dynamic total of
the number of populated cells (not all cells are populated) in this column,
then I'd like to compare the total number of entries to another column (B)
that is populated w/ Xs, Rs and Ns. These letters refer to the status of
the PKI certificates i.e., received, requested or needed. So, I'd like
these values to be a dynamic chart that'll update every time a value is
added or changed. What I'm doing is rolling out PKI installations where
column A is location of the PKI installs and column B is status of PKI
certificates issued to users. I'm also collecting other user information
but is not relevant to this chart. Eventually, I'll convert the spreadsheet
to an access database.
Thanks,
Mike