View Single Post
  #3   Report Post  
Cowtoon
 
Posts: n/a
Default

Thanks for that, coj. I was looking for how to format using exact that (or a
variation on the same theme). Now ... here's a wierd question. In Excel,
there used to be a place to enter a "custom" date/time format, but I can't
find it in this version. Did it get moved.

To answer your question ... it's a line graph with two sets of data plotted
against date-time.
Thanks for your response.
Diana

"coj" wrote:

Cowtoon wrote:
I have date and time in my first column for my x axis, but I can't get both
date and time to display in the chart.

My data spans two weeks and now displays as I want it, but the data is
useless without showing the relevant date/time for the data points (across
the bottom of the chart).

Is there a work around for this. I've tried different date/time cell
formats which will display as I want it in the cell, but can't get the same
display in the chart. I'm not sure what I'm doing wrong.

Thanks for any help. Diana


What sort of graph is it ?

Try formatting the graph's x axis as "hh:mm dd-mmm-yyyy" or something
like that and it should show.