Hello!,

I am using a named range (dynamic: with offset and counta, to include
additional rows automatically) as my chart source (Office 2007). But i
noticed that every time I run the chart it changes the source to the
range itself (absolute) and not using the source as named range.

This is not done through vba.

Is there a way that I can use a dynamic named range in a chart (Office
2007)?

Thanks,

Abdul

You cannot use a named range for the whole data source, you have to have
separate named ranges for each series.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Abdul" wrote in message
...
Hello!,

I am using a named range (dynamic: with offset and counta, to include
additional rows automatically) as my chart source (Office 2007). But i
noticed that every time I run the chart it changes the source to the
range itself (absolute) and not using the source as named range.

This is not done through vba.

Is there a way that I can use a dynamic named range in a chart (Office
2007)?

Thanks,

Abdul

Of course, with VBA you could do this. In the Sheet1 code module (assuming
thee chart and the data are on Sheet1):

Private Sub Worksheet_Change(ByVal Target As Range)
ChartObjects(1).Chart.SetSourceData Source:=Range("MyChartRange")
End Sub

If this fires too frequently (every time a cell is changed), you might try
this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("MyChartRange")) Is Nothing Then
ChartObjects(1).Chart.SetSourceData Source:=Range("MyChartRange")
End If
End Sub


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Bob Phillips" wrote in message
...
You cannot use a named range for the whole data source, you have to have
separate named ranges for each series.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Abdul" wrote in message
...
Hello!,

I am using a named range (dynamic: with offset and counta, to include
additional rows automatically) as my chart source (Office 2007). But i
noticed that every time I run the chart it changes the source to the
range itself (absolute) and not using the source as named range.

This is not done through vba.

Is there a way that I can use a dynamic named range in a chart (Office
2007)?

Thanks,

Abdul