see if it helps
Sub macro1()
Dim cht As Chart
Dim srs As Series
Dim arr As Variant
'change chart name here
Set cht = Sheets("Sheet1").ChartObjects("Chart 1").Chart
For Each srs In cht.SeriesCollection
arr = Split(srs.Formula, ",")
MsgBox "Series Name: " & s
Hi
Pl refer this wonderful resource
http://www.ozgrid.com/forum/showthread.php?t=161559
Let us know if any help needed.
Thanks
On Tue, Jun 25, 2013 at 6:58 PM, Divaker Pandey wrote:
> Hi Group ,
>
> i have added the file, there is a screen shot of chart data range dialog
> box, i want tha
thanks for your quick response.
but i couldn't get, please vabz tell me exact way, how can i get data range
used by chart.
Thanks
On Tue, Jun 25, 2013 at 6:08 PM, VBA VABZ wrote:
> HI
>
> Pl refer:
> http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx
> Using the Cha
HI
Pl refer:
http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx
Using the ChartArea Object
Use the *ChartArea* property to return the *ChartArea* object. The
following example sets the pattern for the chart area in embedded chart one
on the worksheet named "Sheet1."
Wo
hi expert how i can get data range used by chart in excel using vba.
Divaker
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accu
