Graphs with minutes along the bottom

[Lanason]

I have some machine data to display showing running speeds. This is logged every minute when the machine is running but not when stopped.

how do I display a bar graph with a timescale along the bottom of minutes showing gaps when the mchine is down.

 

[The_Doc_Man]

You don't. MS Graph will compress that stuff for you.

But if you make it an XY scatter plot and put data points but don't connect the dots, you can see the trend and yet see the gaps.

XY scatters for minutes will work fine and stay linear. Bar charts will not.

 

[Lanason]

how about this then

Thanks

I have set up a table with minute intervals for a number of days (loads of records) and then used a query to link the times when the machine is running.

Painfull but does show a bar for the speed every minute.

Is there an easy way to set up a table with default minutes - i did it in excell and appended the information