+ Reply to Thread
Results 1 to 2 of 2

Add reference line and notes to chart

Hybrid View

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    melbourne
    MS-Off Ver
    Excel 2010
    Posts
    4

    Add reference line and notes to chart

    hi there

    how can you add

    1.a reference line to a chart which adapts to the scale when additional values are added (ie add a line which is say a numerical value of 20, and keep it at 20 despite the hieght of chart changing when more values are added

    2. add a note to the time scale on x axis which again adapts to the charts but sticks the date you have added the note to (at the moment i draw an arrow and text box and add the note however when i add additional data the axis gets compressed and the arrow no longer represents the same time line)
    Last edited by akelic; 06-06-2013 at 07:07 AM.

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

    Re: Add reference line and notes to chart

    Various ways of adding datum lines to charts
    http://www.andypope.info/charts/averageline.htm

    Notes for specific data points
    http://www.andypope.info/ngs/ng47.htm
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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