chart by cell color or *

N

NealMed

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use color or marked cells to make a chart 5
Avoiding cells being included in a chart 4
Scatter Chart 1
Conditional Datalabel formating 2
How to manually switch data from x axis to y axis in line chart? 1
Change scales from reference cells value for a chart in a separate sheet 4
Green Triangle in Upper Left Corner of Cell 2
Source Range Data changing based on drop-down menu 3

Top