Help, I have a chart within a report (MSGraph.Chart.8) and need to manipulate some of the properties each time it prints for a differrent customer.
Can anyone explain why the first three lines of code work, then fails on the next two:
Chart.charttitle.Font.Size = 8
Chart.Legend.Font.Size = 8
Chart.Axes(1).HasTitle = True ' a text box appears called Axis Title
Chart.Axes(1).Title.Caption = "ABC"
Chart.Axes(1).Font.Size = 20
I get an error message saying 'Object doesn't support this property' however, according the the MSDN website the above structure should work. Please don't tell me my faith in MSDN has been misplaced...
thanks
Paul.
Can anyone explain why the first three lines of code work, then fails on the next two:
Chart.charttitle.Font.Size = 8
Chart.Legend.Font.Size = 8
Chart.Axes(1).HasTitle = True ' a text box appears called Axis Title
Chart.Axes(1).Title.Caption = "ABC"
Chart.Axes(1).Font.Size = 20
I get an error message saying 'Object doesn't support this property' however, according the the MSDN website the above structure should work. Please don't tell me my faith in MSDN has been misplaced...
thanks
Paul.