![]() ![]() Right-click on the x-axis and select "Format Axis.Tip: There are two timeline SmartArt graphics: Basic timeline and Circle Accent Timeline, but you can also use almost any process-related SmartArt graphic. To display the year as 15,000 BC or 2,000 AD, you can use a custom number format: In the Choose a SmartArt Graphic gallery, click Process, and then double-click a timeline layout. Right-click the blank white chart and click Select Data to bring up Excels Select Data Source window. 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. You can follow the question or vote as helpful, but you cannot reply to this thread. 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. Where do I find Templates in Office Excel 2007 I understand Office Excel 2007 has its own templates. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |