Thread: Beginning charting

Hello,

I have just began to chart using Excel.

I have some data calculated by a VBA program and would like to chart it, I was able to do a very simple one but I would like to customize it more.

If you could tell me how to set the maximum x and y value, I would be glad

I was not able to find a simple site which explains how to do simple things (chart color, line type, legend, title ...), if you have any, I will be pleased to check them.

Here is my code

'Initialisation
With Graph1
    Do Until .SeriesCollection.count = 0
        .SeriesCollection(1).Delete
    Loop
End With

With Graph1
    .name = "graph_name"
    .Type = xlLine
    .SeriesCollection.NewSeries.Values = Array(Feval) 'Feval is an array data
End With

Thank you in advance.

Have you tried using the macro recorder?

In xl2010 the recorder catches more of the charting code than in xl2007