Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Shadow Chart
Can we creat Shadow/Duplicate Chart in 2nd Workbook.
for example in Workbook1 i have charts, I want these chart to appear in Workkbook2 as well, when i change data source or apply someformatting on charts in Workbook 1, Charts in Worksheet 2 reflect the changes automatically. Regards |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Shadow Chart
Hi,
You can copy the chart and paste it in the other workbook or sheet and if the data changes for one the other chart will also change. However, the is no built-in way to get the second chart to change formats as the first chart is formatted. But you could use the Camera tool to copy a picture of the chart and paste ii into the other workbook/worksheet. In that case the picture will adjust both values and formatting as the 1st chart changes. The camera tool can be found by choose View, Toolbars, Customize, Commands tab, choose the Tools category and scroll down to Camera, drag the button to a toolbar. Fit the chart nicely in a set of cells and then select the cells behind the chart. Then click the Camera tool and click in your other workbook. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Atif" wrote: Can we creat Shadow/Duplicate Chart in 2nd Workbook. for example in Workbook1 i have charts, I want these chart to appear in Workkbook2 as well, when i change data source or apply someformatting on charts in Workbook 1, Charts in Worksheet 2 reflect the changes automatically. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shadow or Highlight Column in Bar Chart | Charts and Charting in Excel | |||
Chart outline shadow | Charts and Charting in Excel | |||
How do I change the shadow color on a 3-D chart/Graph | Charts and Charting in Excel | |||
How to permanently eliminate shadow as default for chart lines? | Charts and Charting in Excel | |||
Create shadow effect on with chart | Charts and Charting in Excel |