Thread: Vertical lines in a line chart

Hi,
I have a problem with vertical lines in an excel line-chart. I have checked
the available information in excel charts, but it does not work (Jon’s Excel
and Charting Pages). I keep getting a sloping line and cannot place it on the
month I want.
I do not have days on the x-axis but months ranging from Jan. 1999 to June
2003. If I want a line at e.g. June 1999, will that be possible?
Up till now I have done it manually.
Thanks, Enna

Hi enna, try an XY Scatter instead of a Line chart.
Henk

"Enna" wrote:

> Hi,
> I have a problem with vertical lines in an excel line-chart. I have checked
> the available information in excel charts, but it does not work (Jon’s Excel
> and Charting Pages). I keep getting a sloping line and cannot place it on the
> month I want.
> I do not have days on the x-axis but months ranging from Jan. 1999 to June
> 2003. If I want a line at e.g. June 1999, will that be possible?
> Up till now I have done it manually.
> Thanks, Enna
>
>

To elaborate on Henk's post, keep the main chart as a Line chart, but select
the added series, go to the Chart menu and choose Chart Type, and select an
XY type, with lines and no markers.

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


"HEK" <HEK@discussions.microsoft.com> wrote in message
news:D4B704EE-E017-4835-A02D-66DEA355A36F@microsoft.com...
> Hi enna, try an XY Scatter instead of a Line chart.
> Henk
>
> "Enna" wrote:
>
>> Hi,
>> I have a problem with vertical lines in an excel line-chart. I have
>> checked
>> the available information in excel charts, but it does not work (Jon's
>> Excel
>> and Charting Pages). I keep getting a sloping line and cannot place it on
>> the
>> month I want.
>> I do not have days on the x-axis but months ranging from Jan. 1999 to
>> June
>> 2003. If I want a line at e.g. June 1999, will that be possible?
>> Up till now I have done it manually.
>> Thanks, Enna
>>
>>

To elaborate on Henk's post, keep the main chart as a Line chart, but select
the added series, go to the Chart menu and choose Chart Type, and select an
XY type, with lines and no markers.

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


"HEK" <HEK@discussions.microsoft.com> wrote in message
news:D4B704EE-E017-4835-A02D-66DEA355A36F@microsoft.com...
> Hi enna, try an XY Scatter instead of a Line chart.
> Henk
>
> "Enna" wrote:
>
>> Hi,
>> I have a problem with vertical lines in an excel line-chart. I have
>> checked
>> the available information in excel charts, but it does not work (Jon's
>> Excel
>> and Charting Pages). I keep getting a sloping line and cannot place it on
>> the
>> month I want.
>> I do not have days on the x-axis but months ranging from Jan. 1999 to
>> June
>> 2003. If I want a line at e.g. June 1999, will that be possible?
>> Up till now I have done it manually.
>> Thanks, Enna
>>
>>

Hi
It sort of works. At least I now get a straight line, but it is in the wrong
place. It places itself on Jan. 1999 instead of on June 1999. My x-axis is in
the following way:
Jan. 1999 Feb. March April June July Aug. etc. continues Jan. 2000 Feb. etc.
How do I specify that I want it on June?
My mind is not very mathematically, so I think that it may be the bullet
point: "If the x-values are text categories, enter the 'i' number" in yourAdd
a vertical line description, that I don't completely understand.
Sorry for bothering you again, but I often have to put these lines in charts.
Enna

"Jon Peltier" skrev:

> To elaborate on Henk's post, keep the main chart as a Line chart, but select
> the added series, go to the Chart menu and choose Chart Type, and select an
> XY type, with lines and no markers.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "HEK" <HEK@discussions.microsoft.com> wrote in message
> news:D4B704EE-E017-4835-A02D-66DEA355A36F@microsoft.com...
> > Hi enna, try an XY Scatter instead of a Line chart.
> > Henk
> >
> > "Enna" wrote:
> >
> >> Hi,
> >> I have a problem with vertical lines in an excel line-chart. I have
> >> checked
> >> the available information in excel charts, but it does not work (Jon's
> >> Excel
> >> and Charting Pages). I keep getting a sloping line and cannot place it on
> >> the
> >> month I want.
> >> I do not have days on the x-axis but months ranging from Jan. 1999 to
> >> June
> >> 2003. If I want a line at e.g. June 1999, will that be possible?
> >> Up till now I have done it manually.
> >> Thanks, Enna
> >>
> >>
>
>
>

Hi Enna -

What are you using for the X value of the added series? If the first
category is January (i=1), June is probably the 6th, so try using 6 (i=6).
Move it to one side or the other of the category by using ±0.5 (i.e., 5.5 or
6.5), or fine tune it by making similar adjustments.

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


"Enna" <Enna@discussions.microsoft.com> wrote in message
news:C7538CC1-574E-49B8-BCC8-F59DE277379D@microsoft.com...
> Hi
> It sort of works. At least I now get a straight line, but it is in the
> wrong
> place. It places itself on Jan. 1999 instead of on June 1999. My x-axis is
> in
> the following way:
> Jan. 1999 Feb. March April June July Aug. etc. continues Jan. 2000 Feb.
> etc.
> How do I specify that I want it on June?
> My mind is not very mathematically, so I think that it may be the bullet
> point: "If the x-values are text categories, enter the 'i' number" in
> yourAdd
> a vertical line description, that I don't completely understand.
> Sorry for bothering you again, but I often have to put these lines in
> charts.
> Enna
>
> "Jon Peltier" skrev:
>
>> To elaborate on Henk's post, keep the main chart as a Line chart, but
>> select
>> the added series, go to the Chart menu and choose Chart Type, and select
>> an
>> XY type, with lines and no markers.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "HEK" <HEK@discussions.microsoft.com> wrote in message
>> news:D4B704EE-E017-4835-A02D-66DEA355A36F@microsoft.com...
>> > Hi enna, try an XY Scatter instead of a Line chart.
>> > Henk
>> >
>> > "Enna" wrote:
>> >
>> >> Hi,
>> >> I have a problem with vertical lines in an excel line-chart. I have
>> >> checked
>> >> the available information in excel charts, but it does not work (Jon's
>> >> Excel
>> >> and Charting Pages). I keep getting a sloping line and cannot place it
>> >> on
>> >> the
>> >> month I want.
>> >> I do not have days on the x-axis but months ranging from Jan. 1999 to
>> >> June
>> >> 2003. If I want a line at e.g. June 1999, will that be possible?
>> >> Up till now I have done it manually.
>> >> Thanks, Enna
>> >>
>> >>
>>
>>
>>

Hi Jon
Thanks a lot. I have come a long way. I succeeded to put on two vertical
lines, so I'll just go on trying.
Enna

"Jon Peltier" skrev:

> Hi Enna -
>
> What are you using for the X value of the added series? If the first
> category is January (i=1), June is probably the 6th, so try using 6 (i=6).
> Move it to one side or the other of the category by using ±0.5 (i.e., 5.5 or
> 6.5), or fine tune it by making similar adjustments.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Enna" <Enna@discussions.microsoft.com> wrote in message
> news:C7538CC1-574E-49B8-BCC8-F59DE277379D@microsoft.com...
> > Hi
> > It sort of works. At least I now get a straight line, but it is in the
> > wrong
> > place. It places itself on Jan. 1999 instead of on June 1999. My x-axis is
> > in
> > the following way:
> > Jan. 1999 Feb. March April June July Aug. etc. continues Jan. 2000 Feb.
> > etc.
> > How do I specify that I want it on June?
> > My mind is not very mathematically, so I think that it may be the bullet
> > point: "If the x-values are text categories, enter the 'i' number" in
> > yourAdd
> > a vertical line description, that I don't completely understand.
> > Sorry for bothering you again, but I often have to put these lines in
> > charts.
> > Enna
> >
> > "Jon Peltier" skrev:
> >
> >> To elaborate on Henk's post, keep the main chart as a Line chart, but
> >> select
> >> the added series, go to the Chart menu and choose Chart Type, and select
> >> an
> >> XY type, with lines and no markers.
> >>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> http://PeltierTech.com
> >> _______
> >>
> >>
> >> "HEK" <HEK@discussions.microsoft.com> wrote in message
> >> news:D4B704EE-E017-4835-A02D-66DEA355A36F@microsoft.com...
> >> > Hi enna, try an XY Scatter instead of a Line chart.
> >> > Henk
> >> >
> >> > "Enna" wrote:
> >> >
> >> >> Hi,
> >> >> I have a problem with vertical lines in an excel line-chart. I have
> >> >> checked
> >> >> the available information in excel charts, but it does not work (Jon's
> >> >> Excel
> >> >> and Charting Pages). I keep getting a sloping line and cannot place it
> >> >> on
> >> >> the
> >> >> month I want.
> >> >> I do not have days on the x-axis but months ranging from Jan. 1999 to
> >> >> June
> >> >> 2003. If I want a line at e.g. June 1999, will that be possible?
> >> >> Up till now I have done it manually.
> >> >> Thanks, Enna
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>