VBA to copy a table content to a graph

[farzadtb]

Hi all

I have 100 tables to import in a logarithmic graph designed in the same sheet of the tables. After recording the macro I had these lines:

ActiveChart.Axes(xlValue).MajorGridlines.Select

ActiveChart.Axes(xlCategory).Select

ActiveChart.Axes(xlCategory).ScaleType = xlLogarithmic

ActiveChart.Axes(xlCategory).MinimumScale = 10

ActiveChart.FullSeriesCollection(1).Select


After adding the for loop,I couldn't figure out how to run the file, I mean I didn't know which modules should I import via Dim...

Shall someone help me how to complete the code to do the job?

 

[farzadtb]

Anyone