Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Gridlines questions

  1. #1
    Guest

    Default

    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....

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


    Regards,

    Gary Hewitt-Long

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Louisville, KY
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •