Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry i probably wasn't very clear with my initial post - i mean if the user
cuts and pastes as per usual, for instance cuts a chart and pastes it to another sheet in the workbook. I would then want to be able to search for that chart - but at the moment i cannot see a way of identifying it as the chart that my original object held. Here is how I set up my object: Dim oChartObj As ChartObject Dim oGridChart As XL3GridChartLib.GridChart Set oGridChart = New XL3GridChartLib.GridChart Set oGridChart.ChartObject = oGridChart.Sheet.ChartObjects.Add(200, 3, 280, 175) the gridchart object then does a bunch of stuff to get all the data it needs "K Dales" wrote: Can you show the code where you do the cut and paste (and the object variable Dim statements would be helpful also) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing values of two charts | Excel Worksheet Functions | |||
Stacked Charts Comparing 2 Years On 2 Different Sheets | Excel Discussion (Misc queries) | |||
Charts and Line Graphs comparing companies with different data | Charts and Charting in Excel | |||
Charts comparing data | Charts and Charting in Excel | |||
Comparing charts dynamically | Charts and Charting in Excel |