software

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,
AnnaAnna, 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

quot; wrote:

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

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.

quot;HEKquot; wrote:

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

try
format axisgt;patternsgt;linesgt;customgt;weight

--
Don Guillett
SalesAid Software

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

quot;Don Guillettquot; wrote:

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

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

quot;ju1eshartquot; wrote:

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

try selecting the AXIS by right click on a number at the bottomgt;format
axisgt;gt;gt;gt;

--
Don Guillett
SalesAid Software

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

quot;Don Guillettquot; wrote:

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

sure

--
Don Guillett
SalesAid Software

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