chart by cell color or *
 

We have an excel 2002 shared workbook that we use to keep track of our
capacity for incoming patients. The cells are color coded for each different
insurance.
How can i build a chart to show how many of each insurance we have taken in
each week. Some of the cells will contain a *, that we'd like to be able to
have in the chart as well.
The cell range looks like this. ='2268 SEATTLE'!$B$5:$H$13,'2268
SEATTLE'!$B$17:$H$25,'2268 SEATTLE'!$B$35:$H$43,'2268
SEATTLE'!$B$47:$H$55,'2268 SEATTLE'!$B$65:$H$73,'2268
SEATTLE'!$B$77:$H$85,'2268 SEATTLE'!$B$95:$H$103,'2268 SEATTLE'!$B$107:$H$115
We would like to be able to keep track of each one. Can this be done?
--
NealMed