A chart that is updated per hour

[Artpop12]

Hello!
I'd be happy if anyone of you could help me!

I would like to make a chart with about 100 or so cells. I want each cell to be updated per hour.
Lets say:

Cells
2
4
6
9

I want every cell's number to grow (+1) per hour.

So it'll look like this after 1 hour.

Cells
3
5
7
10

Is this possible? How can I do it?


Thank you very much for anyone who's willing to help

 

[rpaulson]

here you go.

Sub OnTimeMacro()
Application.OnTime Now + TimeValue("01:00:00"), "add"
End Sub


Sub add()
Set myRng = Range("C4:F4")

For Each cell In myRng
        If cell > 0 Then cell.Value = cell.Value + 1
Next

Call OnTimeMacro
End Sub

 

[Artpop12]

Thank you very much guys!

 

[Artpop12]

A Chart that updates every hour!

Hey! I posted here earlier but here is a much more detailed post. Hope you guys can help me out!


I want to create some kind of chart that will work the same way as this site works. Live iTunes Popularity Bars

This is a real live chart of the iTunes charts, showing which songs are currently popular and which aren't.

I need to create a simple chart like this with about 100 cells. All of cells will get updated per hour.


I want every song to get (+0.25) growth per hour.
If I want to give a song a bigger growth, I want to just be able to edit it whenever I want.
After 2 weeks of the song charting in this chart, it should show a decline (-0.25) per hour.
If I want to give a song a bigger decline, I want to just be able to edit it whenever I want as well.

Growth= Cell goes green
Decline= Cell goes red

I want every song to grow by 25% per hour.
I will for example, write a random Top 10 songs chart.
Here you go for example:

1.The Weeknd- The Hills 1.000
2.Justin Bieber- Baby 0.890
3.The Weeknd- Can't Feel 0.700
4.Selena Gomez- Good For 0.642
5.Fetty Wap- 679 0.540
6.Drake- Hotline Bling 0.520
7.Ed Sheeran- Photograph 0.220
8.Taylor Swift- Wild 0.190
9.Demi Lovato- Fire 0.100
10. Macklemore- Go 0.050


I inserted their data in the first place!
But I want each song to grow by +0.25 per hour. If I choose to give the song a bigger growth, then I want to be able to edit it by myself.
If a cell gets growth= cell turns green

Now, if a song is already 2 weeks on the chart, it will start to decline by -0.25. And same goes with this. If I choose to give the song a bigger decline, then I want to be able to edit it by myself.
If a cell declines= cell turns red.

1.000 is the maximum and represents the maximum popularity for a song.

Hope you understand and hope you can help me out with this! It would mean soo much

 

[Jon von der Heyden]

Re: A Chart that updates every hour!

Hi Artpop

You seem to be posting new threads of the same question. Per the forum rules (see my signature) - you should keep the same question (and related follow-ups, clarifications a bumps) to the same thread. I've merged your threads into a single thread.