+ Reply to Thread
Results 1 to 7 of 7

Excel Chart - Text on a Timeline

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    West Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Excel Chart - Text on a Timeline

    Hello,
    I'm trying to show short notes on a timeline using Excel 2010. I cannot find a chart to do this. I've tried using a Scatter Plot chart with the Horizontal Axis as a Date Axis and then turned Value Display "On".

    I've mocked up what I would like to accomplish (it is attached).

    Thank You
    Doug Brown
    Attached Images Attached Images

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Excel Chart - Text on a Timeline

    The closest thing that immediately springs to my mind is Jon Peltier's method of filling column charts with wordart.

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

    Re: Excel Chart - Text on a Timeline

    Use a line chart and link data labels to cells using this free addin.
    http://www.appspro.com/Utilities/ChartLabeler.htm

    I added 2 series to the example chart. One displays the short description. The other the exact date, which might be more helpful than the dates provided by the category axis.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    06-20-2012
    Location
    West Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Excel Chart - Text on a Timeline

    Thanks for the replies, however I really wish to avoid a category chart as it require constant time interval data points to show a time relation to events.

    The reason this is important to me is that I have other "scatter line" charts with date/values and wish to synchronize the notes along with the chart to help better explain the data trends based on the notes, without manually adding a text box to every data point in the chart. This also become more daunting when I attempt to change the date range of the chart and have to move/delete/create text boxes to match the time they correspond with.

    Thank you for your suggestions
    Doug Brown

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

    Re: Excel Chart - Text on a Timeline

    Did you check my example?

    The dates are scattered along the axis. It just when you use a line chart with dates the labelling is a little more intelligent about how it groups dates.
    That said there is no reason why the prinicple can not be applied to a scatter.

  6. #6
    Registered User
    Join Date
    06-20-2012
    Location
    West Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Excel Chart - Text on a Timeline

    Andy,
    I did try the chart example you attached, however it was in categories and I didn't attempt to convert to a scatter chart.

    I just tried converting it to a scatter chart and the results are what I was looking for. Thank you very much for you advice and suggestions.

    Doug Brown

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

    Re: Excel Chart - Text on a Timeline

    The axis had dates grouped by months.

    If you change that to days you get a better time line appearance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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