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: to allow for a high level of comparability in business statistics among the North. You can format individual markers and data labels by first selecting an individual data point or label. NAICS was developed under the auspices of the Office of Management and. 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).

This free project management template is available in Excel 2007, 2010, 2013,2016 to. 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. Download Project Tracker Timeline Template Microsoft Excel. 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.