+ Reply to Thread
Results 1 to 4 of 4

crosslines on graph

  1. #1
    Registered User
    Join Date
    01-25-2011
    Location
    Milan, Italy
    MS-Off Ver
    Excel 2007
    Posts
    62

    crosslines on graph

    hello everybody,

    I have a very simple graph. X and Y axes give me a result in the form of a dot. Now I would like to see also the cross lines and, if possible, I would like to be able to decide how long they should be (as the graph will contain 3 dots, very close to each others, I don't want it to be too messy).

    Is it possible?

    Thank you all

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: crosslines on graph

    Not sure what you mean by crosslines. If you mean a lines running from dot to axes then you could use error bars.

    Or you could use another series plotted as xy-scatter line.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: crosslines on graph

    By Cross Line U mean grid lines?

    If yes, in the chart Tools>> layout, there are options
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  4. #4
    Registered User
    Join Date
    01-25-2011
    Location
    Milan, Italy
    MS-Off Ver
    Excel 2007
    Posts
    62

    Re: crosslines on graph

    Quote Originally Posted by Andy Pope View Post
    Not sure what you mean by crosslines. If you mean a lines running from dot to axes then you could use error bars.

    Or you could use another series plotted as xy-scatter line.

    Error bars is what I was looking for.

    Thank you very much for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  2. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 PM
  3. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  4. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  5. [SOLVED] Hyperlinkage of one graph with another graph or Drill down graph
    By Sanjay Kumar Singh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 08:25 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1