I have a spreadsheet with samples normally taken on a weekly basis. Rather
than plot the data against the week I want to plot it against a running hours
figure that is also entered onto the sheet. However if no samples have been
taken this leaves a blank and a gap in my line chart for trending and doesn't
seem to allow the running hours to be used as numbers but just sees them as a
piece of text or category. I want to see the dat against running hours at the
correct spacing of hours. I'm sure that made sense to me as I wrote it!! any
help will be appreciated

Make an XY chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Robin B" <Robin wrote in message
...
I have a spreadsheet with samples normally taken on a weekly basis. Rather
than plot the data against the week I want to plot it against a running
hours
figure that is also entered onto the sheet. However if no samples have
been
taken this leaves a blank and a gap in my line chart for trending and
doesn't
seem to allow the running hours to be used as numbers but just sees them
as a
piece of text or category. I want to see the dat against running hours at
the
correct spacing of hours. I'm sure that made sense to me as I wrote it!!
any
help will be appreciated