How do you plot real time data into a line graph?

Hi,

I have data recorded directly into a spreadsheet as the data becomes available, which I would like to plot in a line graph in real time.
e.g.
row 1 = 11:42:00 = 10
row 2 = 11:43:00 = 9
row 3 = 11:46:00 = 15

so to clarify I would like the x-axis to detail each minute like:
11:42:00 = 10
11:43:00 = 9
11:44:00 = 0
11:45:00 = 0
11:46:00 = 15

Thanks in advance

Are the time and values in two different rows?

If so, just make the range of the graph to where the data will end, not where the data will start; so, for example, use A1:B1000 to create the graph, and then as row A10:B10 is populated for example, the graph will automatically update. Simple!

If they're not in separate rows you're going to have to split them into helper columns, in like B:C for example.

Well, if you're adding them in with VBA or an external data link from some data acquisition hardware or something, then there might be problems with how that works out.

Hi Ben,

Thank you for your response, however I don't think my explanation was very clear. The issue is not the range included - it is a dynamic range, but the missing data on minutes that do not record an entry.

My x-axis is showing 11.42, 11.43,11.46 instead of 11.42, 11.43, 11.44, 11.45, 11.46 where no data was recorded for two minutes, (I would like this to show as zero on the graph so that every minute is captured).

The data is directly imported from a scale, so only records weights that it deems acceptable and the time that it was authorised.

Many Thanks

example data.xlsx I have attached some sample data of how the raw information is imported.
What I plan to do is count how many entries occur in each minute and plot this in a graph. The issue occurs when the scale is not running for a period of time (e.g.02:56:00 to 03:19:59 data is missing) - this data/ times would not be recorded, and therefore the graph would not plot these minutes on the x-axis. I want to achieve a timeline / time-series.

Many Thanks

Thank you MrShorty - I have used the =Frequency() Method which works as requested

I wanted to avoid having 1440 rows and Frequency/CountIfs, hoping that excel would have a built in function that would identify the column as time values and give you an option to plot as I wanted (No Such Luck!).

Not to worry - I can work with your solution

Many Thanks for your help - much appreciated!