| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use color or marked cells to make a chart
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make a cell a price off another cells color | Excel Discussion (Misc queries) | |||
| Applying conditional formating to make cells change color | Excel Discussion (Misc queries) | |||
| Counting Marked Cells | Excel Worksheet Functions | |||
| How do globally clear pre-marked cells | Excel Worksheet Functions | |||
| can I make Blank cells a color? | New Users to Excel | |||
Threaded Mode
