Format Graph Using Vba

[TimTDP]

Is there a method to format a graph using vba?

I need to create a line graph and, using VBA, would like to:
* set line colour
* set line thickness

Bearing in mind that the graph will have numerous lines!

Thanks in advance

 

[Mr. B]

There multiple methods for working with graphs.

Here is a link that might get you pointed in the right direction.

http://msaccesstips.com/2008/06/working-with-chart-object-in-vba/

 

[ChrisO]

Something to play with: -

With Me.[color=blue]chtTestChart[/color].SeriesCollection(1).Border
    .Color = 255
    .Weight = 4
End With

HTH

Chris.

 

[darbid]

Is there a method to format a graph using vba?

I need to create a line graph and, using VBA, would like to:
* set line colour
* set line thickness

Bearing in mind that the graph will have numerous lines!

Thanks in advance

Hi Tim,

I am not an expert at these graphs but I have need to do it as well. MSGraph is the object model (all those methods, properties and functions) used by Access and it is pretty similar to the Charts in Excel. Thus if I wanted to do what you wanted to do, I would make a little Chart in excel and then turn on the macro recorder and set the colour or thicknes etc.

I would say almost 95% of the things that Excel does you can do with the Graph object in Access.