Excel Help

Discussion in 'Bulletin Board ARCHIVE' started by Mido, Apr 2, 2014.

  1. Mid

    Mido Well-Known Member

    Joined:
    Apr 1, 2006
    Messages:
    12,029
    Likes Received:
    7,387
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    Can anyone tell me how to add lines to the x and y axes on a line graph on the newest excel please?

    Looking for something like the lines on this?

    [​IMG]
     
    Mido, Apr 2, 2014
    #1
  2. ita

    italrosso Active Member

    Joined:
    Jan 18, 2006
    Messages:
    708
    Likes Received:
    33
    Trophy Points:
    28
    Home Page:
    Style:
    Barnsley (full width)
    I don't know, but as a quick workaround you could copy the Excel graph to PowerPoint or Word and then draw lines to your heart's content. Nice econ101 there!


    Sent from my iPad using Tapatalk
     
    italrosso, Apr 2, 2014
    #2
  3. M1 Tyke

    M1 Tyke New Member

    Joined:
    Jul 17, 2005
    Messages:
    1,926
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    The only Tory in the village
    Location:
    Somewhere between Dirty Leeds and That London
    Home Page:
    Put your data into the cells.

    Do the chart wizard

    right click on your chart

    Select format chart data.

    Click on the little paint pot thing.

    There's a menu therefore axis.
     
    M1 Tyke, Apr 2, 2014
    #3
  4. Sim

    Simon De Montforte Well-Known Member

    Joined:
    Nov 14, 2009
    Messages:
    5,330
    Likes Received:
    4,766
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    If you click on the "Insert" tab and open up "Shapes" you can draw a line anywhere you want to on a graph. Can be dotted and any colour you want.
     
    Simon De Montforte, Apr 3, 2014
    #4

Share This Page