Graph showing all records along X

[cptraisin]

Hi all,

Say I have a database with 30 records, one for every day of the month.

Within each record I can enter if I've exercised that day and for how long.

What I would like is in a separate layout to have a graph, Y axis being how long I exercised and X axis being 0-30.

The problem I run into is that I end up with the graph only showing me the days I exercised and not all the days.

Any ideas?

[Matthew F]

What if you put in zeros on the off days?

[comment]

See if this helps:

Unfortunately, I don't know of a practical way to make the bars a single color.

MoBars.zip

[cptraisin]

Thanks man

Get ( RecordNumber ) is a smart way to do it.

Thanks, this forum is a life saver.