Modify Legend on Chart

[Kflasph]

Is there a way to modify/add information to the legend on a chart.
I have created a chart and have change the column color based on the value the column is based upon.

I would like for the legend to display the colors and what they mean.

Is this possible?

Thanks in advance.

 

[SkipVought]

Hi,

You must build your own legend with lines or rectangles for each color.

OR...

break your source data into different columns/rows for each series of the color you choose for the series rather than the data point.

Skip,

_[red][/red]

 

[Kflasph]

I didn't think it would be as easy - thanks for the ideas.