If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|