Right-click on the x-axis and select "Format Axis. To display the year as 15,000 BC or 2,000 AD, you can use a custom number format: You can format individual markers and data labels by first selecting an individual data point or label. When working with the positioning of the events, I find it easiest to set the Min/Max bounds for the horizontal axis to -110 and 110 (or 0 and 110). If you want the vertical axis on the left and all events on the right, set the horizontal axis Minimum value to 0 and edit the Positions in the table to be all positive numbers. Finally, create as many fields as necessary to map out all data and choose the layout that best fits the timeline using the ‘SmartArt Design’ tab. Next, click the ‘Process’ option and select the ‘Basic Timeline’ tool. In this tutorial, we’ll look at a quick at an easy way to create a timeline in Excel using the new features found in the 2007 version of this spreadsheet application. First, click the ‘Insert’ tab and then ‘Insert a SmartArt Graphic.’. At this point, all that is left is to format your chart how you want it and edit the position values for each of the events to get everything to fit nicely.įormat the vertical axis (color, min/max values, number format, etc.) by right-clicking on the axis and selecting Format Axis. There are several methods that can be used to construct a project timeline in Excel 2007 and some more arduous than others.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |