Change 1 gridline

This is probably a very easy question I just haven't spent a lot of
time with Excel charts. How do you change the style of 1 gridline on a
chart?

The data on the Y axis is from -2 to 6 and we would like the line at 0
to be darker than the other gridlines.

Thanks,
Anna

Anna, isn't this line just your category axis? Then just select the
gridlines and change their colour, e.g. light grey / dotted, to discriminate
from the cat axis
Regards,
Henk

"[email protected]" wrote:

> This is probably a very easy question I just haven't spent a lot of
> time with Excel charts. How do you change the style of 1 gridline on a
> chart?
>
> The data on the Y axis is from -2 to 6 and we would like the line at 0
> to be darker than the other gridlines.
>
> Thanks,
> Anna
>
>

This edits all gridines, I've been trying to use a gridline as a
cut-off/target but I only want to edit the colour of one specific gridline.

"HEK" wrote:

> Anna, isn't this line just your category axis? Then just select the
> gridlines and change their colour, e.g. light grey / dotted, to discriminate
> from the cat axis
> Regards,
> Henk
>
> "[email protected]" wrote:
>
> > This is probably a very easy question I just haven't spent a lot of
> > time with Excel charts. How do you change the style of 1 gridline on a
> > chart?
> >
> > The data on the Y axis is from -2 to 6 and we would like the line at 0
> > to be darker than the other gridlines.
> >
> > Thanks,
> > Anna
> >
> >

try
format axis>patterns>lines>custom>weight

--
Don Guillett
SalesAid Software
[email protected]
"ju1eshart" <[email protected]> wrote in message
news:[email protected]...
> This edits all gridines, I've been trying to use a gridline as a
> cut-off/target but I only want to edit the colour of one specific
> gridline.
>
> "HEK" wrote:
>
>> Anna, isn't this line just your category axis? Then just select the
>> gridlines and change their colour, e.g. light grey / dotted, to
>> discriminate
>> from the cat axis
>> Regards,
>> Henk
>>
>> "[email protected]" wrote:
>>
>> > This is probably a very easy question I just haven't spent a lot of
>> > time with Excel charts. How do you change the style of 1 gridline on a
>> > chart?
>> >
>> > The data on the Y axis is from -2 to 6 and we would like the line at 0
>> > to be darker than the other gridlines.
>> >
>> > Thanks,
>> > Anna
>> >
>> >

even if i select one gridline and fomat axis the format is still applied to
all gridlines. jules

"Don Guillett" wrote:

> try
> format axis>patterns>lines>custom>weight
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "ju1eshart" <[email protected]> wrote in message
> news:[email protected]...
> > This edits all gridines, I've been trying to use a gridline as a
> > cut-off/target but I only want to edit the colour of one specific
> > gridline.
> >
> > "HEK" wrote:
> >
> >> Anna, isn't this line just your category axis? Then just select the
> >> gridlines and change their colour, e.g. light grey / dotted, to
> >> discriminate
> >> from the cat axis
> >> Regards,
> >> Henk
> >>
> >> "[email protected]" wrote:
> >>
> >> > This is probably a very easy question I just haven't spent a lot of
> >> > time with Excel charts. How do you change the style of 1 gridline on a
> >> > chart?
> >> >
> >> > The data on the Y axis is from -2 to 6 and we would like the line at 0
> >> > to be darker than the other gridlines.
> >> >
> >> > Thanks,
> >> > Anna
> >> >
> >> >
>
>
>

continued from below,it's a 3D chart, I have several gridlines log scale 0.1
to 1.0E+08 and gridlines evey 10

"ju1eshart" wrote:

> even if i select one gridline and fomat axis the format is still applied to
> all gridlines. jules
>
> "Don Guillett" wrote:
>
> > try
> > format axis>patterns>lines>custom>weight
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "ju1eshart" <[email protected]> wrote in message
> > news:[email protected]...
> > > This edits all gridines, I've been trying to use a gridline as a
> > > cut-off/target but I only want to edit the colour of one specific
> > > gridline.
> > >
> > > "HEK" wrote:
> > >
> > >> Anna, isn't this line just your category axis? Then just select the
> > >> gridlines and change their colour, e.g. light grey / dotted, to
> > >> discriminate
> > >> from the cat axis
> > >> Regards,
> > >> Henk
> > >>
> > >> "[email protected]" wrote:
> > >>
> > >> > This is probably a very easy question I just haven't spent a lot of
> > >> > time with Excel charts. How do you change the style of 1 gridline on a
> > >> > chart?
> > >> >
> > >> > The data on the Y axis is from -2 to 6 and we would like the line at 0
> > >> > to be darker than the other gridlines.
> > >> >
> > >> > Thanks,
> > >> > Anna
> > >> >
> > >> >
> >
> >
> >

try selecting the AXIS by right click on a number at the bottom>format
axis>>>>

--
Don Guillett
SalesAid Software
[email protected]
"ju1eshart" <[email protected]> wrote in message
news:[email protected]...
> even if i select one gridline and fomat axis the format is still applied
> to
> all gridlines. jules
>
> "Don Guillett" wrote:
>
>> try
>> format axis>patterns>lines>custom>weight
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "ju1eshart" <[email protected]> wrote in message
>> news:[email protected]...
>> > This edits all gridines, I've been trying to use a gridline as a
>> > cut-off/target but I only want to edit the colour of one specific
>> > gridline.
>> >
>> > "HEK" wrote:
>> >
>> >> Anna, isn't this line just your category axis? Then just select the
>> >> gridlines and change their colour, e.g. light grey / dotted, to
>> >> discriminate
>> >> from the cat axis
>> >> Regards,
>> >> Henk
>> >>
>> >> "[email protected]" wrote:
>> >>
>> >> > This is probably a very easy question I just haven't spent a lot of
>> >> > time with Excel charts. How do you change the style of 1 gridline
>> >> > on a
>> >> > chart?
>> >> >
>> >> > The data on the Y axis is from -2 to 6 and we would like the line at
>> >> > 0
>> >> > to be darker than the other gridlines.
>> >> >
>> >> > Thanks,
>> >> > Anna
>> >> >
>> >> >
>>
>>
>>

can I e-mail to you at austin.rr

"Don Guillett" wrote:

> try selecting the AXIS by right click on a number at the bottom>format
> axis>>>>
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "ju1eshart" <[email protected]> wrote in message
> news:[email protected]...
> > even if i select one gridline and fomat axis the format is still applied
> > to
> > all gridlines. jules
> >
> > "Don Guillett" wrote:
> >
> >> try
> >> format axis>patterns>lines>custom>weight
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> [email protected]
> >> "ju1eshart" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > This edits all gridines, I've been trying to use a gridline as a
> >> > cut-off/target but I only want to edit the colour of one specific
> >> > gridline.
> >> >
> >> > "HEK" wrote:
> >> >
> >> >> Anna, isn't this line just your category axis? Then just select the
> >> >> gridlines and change their colour, e.g. light grey / dotted, to
> >> >> discriminate
> >> >> from the cat axis
> >> >> Regards,
> >> >> Henk
> >> >>
> >> >> "[email protected]" wrote:
> >> >>
> >> >> > This is probably a very easy question I just haven't spent a lot of
> >> >> > time with Excel charts. How do you change the style of 1 gridline
> >> >> > on a
> >> >> > chart?
> >> >> >
> >> >> > The data on the Y axis is from -2 to 6 and we would like the line at
> >> >> > 0
> >> >> > to be darker than the other gridlines.
> >> >> >
> >> >> > Thanks,
> >> >> > Anna
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>
>

sure

--
Don Guillett
SalesAid Software
[email protected]
"ju1eshart" <[email protected]> wrote in message
news:[email protected]...
> can I e-mail to you at austin.rr
>
> "Don Guillett" wrote:
>
>> try selecting the AXIS by right click on a number at the bottom>format
>> axis>>>>
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "ju1eshart" <[email protected]> wrote in message
>> news:[email protected]...
>> > even if i select one gridline and fomat axis the format is still
>> > applied
>> > to
>> > all gridlines. jules
>> >
>> > "Don Guillett" wrote:
>> >
>> >> try
>> >> format axis>patterns>lines>custom>weight
>> >>
>> >> --
>> >> Don Guillett
>> >> SalesAid Software
>> >> [email protected]
>> >> "ju1eshart" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > This edits all gridines, I've been trying to use a gridline as a
>> >> > cut-off/target but I only want to edit the colour of one specific
>> >> > gridline.
>> >> >
>> >> > "HEK" wrote:
>> >> >
>> >> >> Anna, isn't this line just your category axis? Then just select
>> >> >> the
>> >> >> gridlines and change their colour, e.g. light grey / dotted, to
>> >> >> discriminate
>> >> >> from the cat axis
>> >> >> Regards,
>> >> >> Henk
>> >> >>
>> >> >> "[email protected]" wrote:
>> >> >>
>> >> >> > This is probably a very easy question I just haven't spent a lot
>> >> >> > of
>> >> >> > time with Excel charts. How do you change the style of 1
>> >> >> > gridline
>> >> >> > on a
>> >> >> > chart?
>> >> >> >
>> >> >> > The data on the Y axis is from -2 to 6 and we would like the line
>> >> >> > at
>> >> >> > 0
>> >> >> > to be darker than the other gridlines.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Anna
>> >> >> >
>> >> >> >
>> >>
>> >>
>> >>
>>
>>
>>