Thread
:
Naming a range and then use it to create chart
View Single Post
#
2
Posted to microsoft.public.excel.programming
AndrewArmstrong
external usenet poster
Posts: 24
Naming a range and then use it to create chart
When you get the error and click "debug", what line is highlighted?
wrote:
I have been struggling with this for hours and I seriously think this
is just a syntax error so if somebody can help me, I will really
appreciate it.
I check on previous topics in the discussion and I think this is the
right way to declare a name for range,
Let say in this case FNMACounter is 57 thus I want the range of A1:B57
as FNMARange
--------------------------------------------------------------------------------------------------------------------------------
Range(Cells(1, 1), Cells(FNMACounter, 2)).Name = "FNMARange"
----------------------------------------------------------------------------------------------------------------------------------
And then I used macro to create the chart,
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("FNMA
temp").Range("FNMARange"), _
PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:="Main Data"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "FNMA Chart"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text =
"Maturity Dates"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Yield"
End With
ActiveChart.HasLegend = False
somehow it keeps getting me application or object defined error, does
anybody know whats wrong with my code. Thank you!
Reply With Quote
AndrewArmstrong
View Public Profile
Find all posts by AndrewArmstrong