I have a database that is currently capturing live data from various processes. I am developing a front end that will display various ‘real time’ information for the relevant users, mostly though graphs (Charts)
I am using some VBA / SQL to get information from the tables, do some calcs and then give me the raw data I need to put in the graph. (See attachment for example) I need to update the graphs every 5 minutes to give out ‘real time’ information.
I did try and dump the data into a table and link the table to the graph, but I just can’t get the graph to do what I want it to do that way. (i.e. I want the x-axis to show the 8 hours in the day but I am only populating information by one hour at a time as it is real time info.)
Is there a way I can put data directly into the graph’s datasheet from my VBA code (triggered by a timer event in the form) and then update the graph at runtime that way?
I did look at using an ActiveX chart control, but I’ve not worked with these before and I couldn’t figure it out.
I am using some VBA / SQL to get information from the tables, do some calcs and then give me the raw data I need to put in the graph. (See attachment for example) I need to update the graphs every 5 minutes to give out ‘real time’ information.
I did try and dump the data into a table and link the table to the graph, but I just can’t get the graph to do what I want it to do that way. (i.e. I want the x-axis to show the 8 hours in the day but I am only populating information by one hour at a time as it is real time info.)
Is there a way I can put data directly into the graph’s datasheet from my VBA code (triggered by a timer event in the form) and then update the graph at runtime that way?
I did look at using an ActiveX chart control, but I’ve not worked with these before and I couldn’t figure it out.
