You are correct that the colors are decided as the patients are populated, I
thought about choosing columns by insurance, however, because it's designed
to be populated by date, much like scheduling appt's. That makes it very
difficult to design that way. I thought of placing something like * in
certain catagories that i'd like to build the graph from, is that possible?
--
NealMed


"Jon Peltier" wrote:

And let me guess, you manually color code the cells as they are populated?
Why not add a column with the name of the insurance company? You can then
sort by that column, or filter the data, or make a pivot table to show what
you want to show.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"NealMed" wrote in message
...
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.
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