Lina
05-09-2011, 11:40 PM
Hi
Please may I ask, is it possible to set the colors in the legend to match the colors set for a cell.
I have a table that has 14 columns. The first is a list of names, the second a list of codes for the names, the following columns contain ratings are values assigned to each name. Each Column has been assigned a color. This is done on a monthly basis.
I need to create a chart to reflect the values/ratings found in the cells, as well as the colors for each rating.
Is it possible to do this.
Thank you
Lina
Please may I ask, is it possible to set the colors in the legend to match the colors set for a cell.
I have a table that has 14 columns. The first is a list of names, the second a list of codes for the names, the following columns contain ratings are values assigned to each name. Each Column has been assigned a color. This is done on a monthly basis.
I need to create a chart to reflect the values/ratings found in the cells, as well as the colors for each rating.
Is it possible to do this.
Thank you
Lina