Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    graph lines (Microsoft Office Excel 2007)

    I am making a graph with the left axis as 0 through 100. I am trying to make the 80 and the line for the 80 bold. How can you select just one line and one # in the axis to make bold?

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graph lines (Microsoft Office Excel 2007)

    I admit that I speak under correction here, but I don't think this is possible under normal circumstances in Excel 2007. The gridlines and the axis values are each seen as elements of the chart and you cannot get access to an individual gridline or axis number. The workaround is to manually draw in the line, superimposing over the original gridline, and using a small textbox to cover the axis value and typing 80 into the text box.

    If memory serves me correctly, 2003 charts were a little more flexible and one could select items within the elements, but this is not the case with the remodeled graphics engine in 2007.
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: graph lines (Microsoft Office Excel 2007)

    You could add another series to the chart, with all values set to 80, and display it as a black line.

    StuartR

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,939
    Thanks
    0
    Thanked 94 Times in 90 Posts

    Re: graph lines (Microsoft Office Excel 2007)

    Just FYI, 2003 and prior were no more flexible in that respect, sadly.
    Regards,
    Rory
    Microsoft MVP - Excel.

Posting Permissions

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