Hi,

The camera tool allows you to display what ever is in or above a range of
cells.
So I guess you would need to select the cells under the chart legend.

If the button is grayed out it would suggest you have a chart sheet rather
than an object on a worksheet.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mifty" wrote in message
...
Hi everyone,

I was hoping to be able to use the camera tool to copy the legend box to
use
for a series of graphs that will be displayed together to make the space
for
each chart larger.

Unfortunately it greys out when I try to select any elements of the chart.

Does anyone know how I can do this please

Cheers
--
Mifty