Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Camera Tool
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Camera Tool
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Camera Tool
Hi Andy,
Still stuck. The chart is an object on the same worksheet as raw data and not as a separate sheet. Is that what you meant? I can only select a chart within a range of cells. If I click on the chart itself the camera tool greys out. Hoping you can help Cheers -- Mifty "Andy Pope" wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Camera Tool
As I said the camera tool links to cells not shapes or chart or elements
within charts. It will display shapes, charts etc if they are positioned over the range of cells the camera is linked to. So you need to select the cell that the legend is covering. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mifty" wrote in message ... Hi Andy, Still stuck. The chart is an object on the same worksheet as raw data and not as a separate sheet. Is that what you meant? I can only select a chart within a range of cells. If I click on the chart itself the camera tool greys out. Hoping you can help Cheers -- Mifty "Andy Pope" wrote: 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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Camera Tool
Ah I see...
Thanks Andy Cheers -- Mifty "Andy Pope" wrote: As I said the camera tool links to cells not shapes or chart or elements within charts. It will display shapes, charts etc if they are positioned over the range of cells the camera is linked to. So you need to select the cell that the legend is covering. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mifty" wrote in message ... Hi Andy, Still stuck. The chart is an object on the same worksheet as raw data and not as a separate sheet. Is that what you meant? I can only select a chart within a range of cells. If I click on the chart itself the camera tool greys out. Hoping you can help Cheers -- Mifty "Andy Pope" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
camera | Setting up and Configuration of Excel | |||
Excel's camera tool | Excel Discussion (Misc queries) | |||
Camera | Excel Discussion (Misc queries) | |||
Camera Feature | Charts and Charting in Excel | |||
Help with Camera Function | Excel Discussion (Misc queries) |