ExcelBanter - legend

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - legend (https://www.excelbanter.com/excel-discussion-misc-queries/210744-legend.html)

I need to place a color-coded legend in an Excel spreadsheet. I tried to
copy and paste into header and can't get the colors into header. Any
suggestions?

Well, you can cheat... Enter the legend as you want it to look. Print Screen,
go to Paint (Start - Programs-Accessories-General Apps) paste and cut off all
the excess. Save as a picture file. Then, go to your header and import the
file.

"Windy" wrote:

I need to place a color-coded legend in an Excel spreadsheet. I tried to
copy and paste into header and can't get the colors into header. Any
suggestions?

Unfortunately, it seems my company has blocked "paint" - I guess they're
afraid I'll play! Any other ideas?

"Sean Timmons" wrote:

Well, you can cheat... Enter the legend as you want it to look. Print Screen,
go to Paint (Start - Programs-Accessories-General Apps) paste and cut off all
the excess. Save as a picture file. Then, go to your header and import the
file.

"Windy" wrote:

I need to place a color-coded legend in an Excel spreadsheet. I tried to
copy and paste into header and can't get the colors into header. Any
suggestions?