ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create a live chart (https://www.excelbanter.com/excel-programming/361394-how-create-live-chart.html)

Debraj Mitra

How to create a live chart
 
I want to know how to create a live chart on Excel from a set of datas which
will change on adaily basis.

bratek[_2_]

How to create a live chart
 


"Debraj Mitra" wrote:

I want to know how to create a live chart on Excel from a set of datas which
will change on adaily basis.


I did a little bit of cheating :)
I made two sub
one create chart and the other delete chart
every time I create chart first I delete it
I put a timer (or you can check if there are new data) and after 1 min it
call create sub :)
I don't know better solution..


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com