Thread: Charting help!

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

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

koday@processtrends.com






"Dezos112" <Dezos112.267kin_1144941007.5008@excelforum-nospam.com> wrote in
message news:Dezos112.267kin_1144941007.5008@excelforum-nospam.com...
>
> 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
>

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

koday@processtrends.com






"Dezos112" <Dezos112.267kin_1144941007.5008@excelforum-nospam.com> wrote in
message news:Dezos112.267kin_1144941007.5008@excelforum-nospam.com...
>
> 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
>

in the first line of my question i stated that it is a line chart. number of sales on the y axis and date's on the x axis.

Many users confuse Line and XY charts.

Line charts can't distinguish time within a day. You will need to use an XY
chart to plot time within a day..

...Kelly


"Dezos112" <Dezos112.267nam_1144944611.6068@excelforum-nospam.com> wrote in
message news:Dezos112.267nam_1144944611.6068@excelforum-nospam.com...
>
> in the first line of my question i stated that it is a line chart.
> number of sales on the y axis and date's on the x axis.
>
>
> --
> Dezos112
> ------------------------------------------------------------------------
> Dezos112's Profile:
> http://www.excelforum.com/member.php...o&userid=33460
> View this thread: http://www.excelforum.com/showthread...hreadid=532643
>