how can I use a number series with gaps in as a chart axis

R

Robin B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Employee Schedule not plotting properly - chart type / data series not correct 0
Chart series select. 3
Creating a Chart on form from selected data in query. 0
Chart SERIES OFFSET 5
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Scatter chart with categories on x-Axis 2
Overlaying 2 Data Series with Different Time (X) Axis 3
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2

Top