Hi, my data in excel has no values, but are color coded (fill color), my question is how am I able to chart it. Here's the scenario. I have four rows, Green, Yellow, Red and Black, columns are each day of the calendar. Each color has a meaning, so I want to graph it (line graph probably) that will show the trend on a daily basis. Thanks. I have tried line graphs with no success or am I doing it wrong........
Bookmarks