Thread: Data Points

How if possible can i get the data points in my chart to sit on the line
itself. i.e.

i have the numbers running along the bottom.

10 15 20 25 30 35 40

but the data states something should be on the 20 line, however the data
point shows in the middle of 20 and 25 so the person lookin a tthe graph
thinks the value is 22.5.

how can i stop this.

Thanks

Craig

Change the chart type from "Line" to "XY (Scatter)".

The "Line" chart is very misleadingly named. It has nothing to do with
whether you want a connecting line or not. A "Line" chart assumes that
the x-axis is non-numeric category labels.

Jerry

CraigM wrote:

> How if possible can i get the data points in my chart to sit on the line
> itself. i.e.
>
> i have the numbers running along the bottom.
>
> 10 15 20 25 30 35 40
>
> but the data states something should be on the 20 line, however the data
> point shows in the middle of 20 and 25 so the person lookin a tthe graph
> thinks the value is 22.5.
>
> how can i stop this.
>
> Thanks
>
> Craig

Hi,

That looks nothing like what is supposed to when i changed that.

Regards

Craig

"Jerry W. Lewis" wrote:

> Change the chart type from "Line" to "XY (Scatter)".
>
> The "Line" chart is very misleadingly named. It has nothing to do with
> whether you want a connecting line or not. A "Line" chart assumes that
> the x-axis is non-numeric category labels.
>
> Jerry
>
> CraigM wrote:
>
> > How if possible can i get the data points in my chart to sit on the line
> > itself. i.e.
> >
> > i have the numbers running along the bottom.
> >
> > 10 15 20 25 30 35 40
> >
> > but the data states something should be on the 20 line, however the data
> > point shows in the middle of 20 and 25 so the person lookin a tthe graph
> > thinks the value is 22.5.
> >
> > how can i stop this.
> >
> > Thanks
> >
> > Craig
>
>

Jerry's suggestion didn't help? What is wrong with the chart now?

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


"CraigM" <CraigM@discussions.microsoft.com> wrote in message
news:34DD8183-DA7B-44CE-96BE-7E2EB3CE03F2@microsoft.com...
> Hi,
>
> That looks nothing like what is supposed to when i changed that.
>
> Regards
>
> Craig
>
> "Jerry W. Lewis" wrote:
>
>> Change the chart type from "Line" to "XY (Scatter)".
>>
>> The "Line" chart is very misleadingly named. It has nothing to do with
>> whether you want a connecting line or not. A "Line" chart assumes that
>> the x-axis is non-numeric category labels.
>>
>> Jerry
>>
>> CraigM wrote:
>>
>> > How if possible can i get the data points in my chart to sit on the
>> > line
>> > itself. i.e.
>> >
>> > i have the numbers running along the bottom.
>> >
>> > 10 15 20 25 30 35 40
>> >
>> > but the data states something should be on the 20 line, however the
>> > data
>> > point shows in the middle of 20 and 25 so the person lookin a tthe
>> > graph
>> > thinks the value is 22.5.
>> >
>> > how can i stop this.
>> >
>> > Thanks
>> >
>> > Craig
>>
>>