LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to find a Chart embedded in a Sheet?

Consider the following chart (this is the macro used to
create the chart):

'---------------------------------------------
------------------------
Charts.Add()
ActiveChart.ChartType = xlXYScatter
ActiveChart.SetSourceData(Source:=Sheets
("Sheet1").Range("A7:C13"), PlotBy _
:=xlColumns)
ActiveChart.Location
(Whe=xlLocationAsObject, Name:="Sheet1")
ActiveSheet.Shapes("Chart 2").IncrementLeft(-
138.75)
ActiveSheet.Shapes("Chart 2").IncrementTop
(26.25)
ActiveWindow.Visible = False
Windows("projected.xls").Activate()
Range("G14").Select()
'=============================================
========================

I've successfully confirmed the .Top and .Left positions
of the Shape, but I can't seem to drill down to the
actual Chart object that was embedded.

I need to verify
the .ChartType, .SeriesCollection.Formula
and .SeriesCollection.Name of this embedded chart, but I
can't seem to find my way to it.

Can someone help me locate the Chart within the Shape?

Thanks, in advance, for your help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find within an embedded document object Giggly4g Excel Discussion (Misc queries) 0 July 25th 08 04:18 AM
Formula using array to find embedded value Ted Horsch Excel Discussion (Misc queries) 9 June 23rd 06 04:28 AM
Embedded Chart Versus Chart - ShowDetail Issue [email protected] Charts and Charting in Excel 1 May 14th 06 04:11 PM
Links in Embedded doc within sheet don't change when sheet is copi Dan k Excel Discussion (Misc queries) 0 May 11th 06 05:41 PM
Embedded Chart in Excel Sheet George Charts and Charting in Excel 3 August 4th 05 12:19 PM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"