Named Range as Chart Source
 

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

Named Range as Chart Source
 

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

Named Range as Chart Source
 

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