| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
| How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
Hybrid Mode
