Thread: Charting help!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default Charting help!

Dezos 112

What type of chart are you using, Line or XY (Scatter)

A line chart uses categorical labels, an XY chart uses numeric value.

If you want to plot your date/time values dimensionally, then you need to
use an XY chart.

When you use a time axis scale for a line chart with day & time data, Excel
plots all points for a day on same X axis location.

With an XY chart, the times will plot correctly.

if you can give us some more details on your problem, I'm sure we can
resolve it.

...Kelly








"Dezos112" wrote in
message ...

Hello all,

I am trying to make a line chart with time intervals on the
bottom of the chart. after i select the data range it shows me the
chart with the correct values and line drawn, however on the bottom of
the graph the dates are all wrong. i have edited the dates and got them
to be the correct times, but now i dont have my line graph or values
they have dissapeared. can someone please help!

thanks


--
Dezos112
------------------------------------------------------------------------
Dezos112's Profile:
http://www.excelforum.com/member.php...o&userid=33460
View this thread: http://www.excelforum.com/showthread...hreadid=532643