multiple chart loop

Hi,

I am learning how to create chart using vba.

this one is using recorder to create first chart.

Please Login or Register  to view this content.

attached is example file ( with manual result ).

I wonder how to repeat the process to create another chart for every four data ( start from 1 and end with 4) until last cell.
with the chart title: date of first cell of every batch.

Appreciate for any help.

Thank you.

Hi,

That's great! work as i expected.

I have few questions,

If ((n - 2) \ 4) Mod 2 = 0 Then
chartLeft = Range("E1").Left
chartTop = ((n - 2) \ 8) * chartHeight + Cells(2, "E").Top

1. what is the meaning of those number?
(n-2)\4 Mod 2 = 0
((n-2)\8)

2. which part should i modified, if i want the chart from 2 ( col E and K) to 4 ( E, J , O, T) per row.

3. how to modify the seriescollection X axis . Current result for x axis is 1,2,3,4 , when i change 1,2,3,4 to 2,4,6,8, the x axis resulted using vba is still 1,2,3,4


Thank you for your time.

any help from other?

still struggling to modify the code.

Thank you for reviewing back my code.

Got compile error: next without for

current result for X, is sequence number 1,2,3,4. the actual will not always 1,2,3,4.

Hi,

Thank you. its work now.
i accidentally delete For n = 2 To lastRow Step 4 causing error : Next without for

nevermind about the x axis, i don't need it.

anyway, how to give space/gap with chart below? current result is first row chart is stick to second row chart.

Thank you so much, you help me learn about chart vba .

Hi,

actually i practice with different set ( 13 data per chart) previously 4 data per chart.

but can't get it right, the charts is overlapping another chart.

attach is the update file contain macro.