dynamic chart using data in rows seperately

MarioDC

New Member
Joined
Apr 11, 2019
Messages
3
I have a list created by reading data every 5 seconds (6 inputs at a time).
I want these rows of data put on a chart one by one.
I've done this for a short list using the record mode as I don't know a thing about VBA.
however, the list contains over 500 rows of data. so loop would be solution for that.
I've been searching the net for a code (loop, offset) but can't get the second part of the range to "offset" by 1. The first part always remains "Sheet1!$B6:$N$6"
I added a timer between each data reading so the evolution can be seen on the chart.

ActiveSheet.ChartObjects("Grafiek 2").Activate
ActiveChart.SetSourceData Source:=Range("Sheet1!$B$6:$N$6,Sheet1!$B$8:$N$8")
Application.Wait (Now + (TimeValue("0:00:02") / 3))
ActiveSheet.ChartObjects("Grafiek 2").Activate
ActiveChart.SetSourceData Source:=Range("Sheet1!$B$6:$N$6,Sheet1!$B$9:$N$9")
Application.Wait (Now + (TimeValue("0:00:02") / 3))
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top