Skip navigation

Making a Timeline

1136 Views 2 Replies Latest reply: Jan 29, 2012 6:26 PM by jimowen800 RSS
jimowen800 Level 1 Level 1 (0 points)
Currently Being Moderated
Jan 25, 2012 10:16 PM

Hi,

 

i've read through all the discussions i can find on Timelines but they dont quite give me the answers im looking for, if i've missed something please direct me to the right place.

 

What im trying to do is plot the births and deaths of several hisorical figures on a timeline in Numbers. below i've given a sample of the data and an example of what i want it to look like (i made it in Pages and it took ages).

Screen Shot 2012-01-26 at 3.50.51 PM.png

any suggestions will be greatly appreciated. also feel free to make any suggestions on improving the appearence.

MacBook Pro, Mac OS X (10.7.2), Numbers
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 26, 2012 12:55 AM (in response to jimowen800)

    Hi Jim,

     

    Here's your data, rearranged on the table, with some added columns, presented as a scatter chart, with connected pairs of data controlling the beginning and end of each 'life line.'

    Picture 5.png

    The numbers in the yellow columns are the y values for each x,y pair. They control the height of the line above the base line.

    The names and symbols on the left are the Legend of the chart, automatically generated, but forced into a vertical stack by decreasing the width of the text box Numbers generated to hold this information.

    The Legend was repositioned to the left of the chart, and Show Y-axis labels was unchecked in the Yaxis options.

    Numbers offers no control over spacing of the list in the legend, so the chart was shortened top to bottom to fit the existing line spacing of the Legend.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.