Gridlines questions

Feb 26th, 2002, 10:28 PM

hi,
I'd like to know if it is possible to show only some part of a gridline in an excel chart. For example if I have a chart with X and Y gridlines and I want to have my line at X=0.2 starting at Y=0.3 whereas the other lines start at Y=0??? Please help....

gplhl · Feb 27th, 2002, 01:06 AM

Quote:

On 2002-02-26 21:28, Anonymous wrote:
hi,
I'd like to know if it is possible to show only some part of a gridline in an excel chart. For example if I have a chart with X and Y gridlines and I want to have my line at X=0.2 starting at Y=0.3 whereas the other lines start at Y=0??? Please help....

Disable gridlines in Tools > Options

and then use cell border formatting instead to create your lines.

Don C · Feb 27th, 2002, 06:44 AM

On a chart, double click on the axis you want to change which brings up the "format axis" dialogue box.

One of the options there is the value where you want the axis to cross. In your case you will do this for both axes, changing the default zero to the values you've chosen.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 10:28 PM	#1
Guest Posts: n/a	hi, I'd like to know if it is possible to show only some part of a gridline in an excel chart. For example if I have a chart with X and Y gridlines and I want to have my line at X=0.2 starting at Y=0.3 whereas the other lines start at Y=0??? Please help....

Feb 27th, 2002, 06:44 AM	#3
Don C Board Regular Join Date: Feb 2002 Location: Louisville, KY Posts: 72	On a chart, double click on the axis you want to change which brings up the "format axis" dialogue box. One of the options there is the value where you want the axis to cross. In your case you will do this for both axes, changing the default zero to the values you've chosen.