Categories: Microsoft Word
In other languages:
Nah, bagi Anda pengguna Microsoft Word 2016, Anda bisa mengikuti tahap-tahap berikut ini untuk membuat Cover CD: 1. Masuk ke dalam Microsoft Word 2016, lalu pilihlah template untuk “Cover CD” dengan cara mencarinya di bagian fitur pencarian. Word Template – Ini akan membuat templat yang kompatibel dengan Word 2007, 2010, dan 2013. Word 97-2003 Template – Ini akan membuat templat yang kompatibel dengan versi Word sebelumnya. Anda mungkin akan kehilangan sebagian perubahan gaya.
Español: hacer tarjetas de presentación en Microsoft Word, Português: Fazer Cartões de Visita no Microsoft Word, Italiano: Creare dei Biglietti da Visita con Microsoft Word, Русский: создать визитные карточки в Microsoft Word, Deutsch: In Microsoft Word Visitenkarten erstellen, Français: réaliser une carte de visite dans Microsoft Word, Nederlands: Visitekaartjes maken met Microsoft Word, Bahasa Indonesia: Membuat Kartu Nama dengan Microsoft Word, العربية: إنشاء بطاقة أعمال في مايكروسوفت وورد, ไทย: ทำนามบัตรด้วยโปรแกรม Microsoft Word, Tiếng Việt: Tạo danh thiếp kinh doanh bằng Microsoft Word, 한국어: 마이크로소프트 워드에서 명함 만드는 방법, Türkçe: Microsoft Word'de Kartvizit Nasıl Yapılır, 中文: 在Microsoft Word中制作名片, हिन्दी: माइक्रोसॉफ्ट वर्ड (Microsoft Word) में बिज़नेस कार्ड (business card) बनाएँ
![Cara Cara](/uploads/1/2/5/7/125714816/502770615.jpg)
- Edit
- Send fan mail to authors
How to create timeline (milestone) chart template in Excel?
Have you tried to create a timeline chart or milestone chart to mark the milestones or important time of a project? This article will show you the detailed steps about creating timeline chart or milestone chart and save it as a chart template in Excel.
Save chart as AutoText and reuse it with only one click in Excel
Kutools for Excel’s Auto Text utility can save a selected chart as an AutoText entry, and you can reuse this chart at any time in any workbook by only one click.Full Feature Free Trial 60-day!
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel - The Best Office Productivity Tool Will Solve Most of Your Excel Problems
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in company; Full features 60-day free trial.
Part 1: Prepare your data for creating timeline/milestone chart
The first section will guide you to prepare data for a timeline/milestone chart creating in Excel.
Step 1: Prepare a table and enter your original data as the following screen shot shown:
Step 2: Add height values for each event in the Column E. You’d better mix the negative numbers and positive numbers in the column.
Step 3: Specify the Axis values for each event. In Cell F2 enter =A2+(DATE(1900,IF(B2=',1,B2),0)+C2)/365.25, and drag the Fill Handle down to apply this formula to the range you want.
Step 4: Specify the Label values for each event. In Cell G2 enter =OFFSET(D2,ROW()-ROW(G2),0,1,1), and drag the Fill handle down to apply this formula to the range you want.
Then you will get a table similar as the following screen shot shown:
Part 2: Create a timeline/milestone chart in Excel
With the first part we have prepared a table (see screen shot above) for timeline/milestone chart creating. And this part will walk you through creating a timeline/milestone chart in Excel.
Step 1: Don’t select any content in the table, and click the Insert > Scatter (or Insert Scatter(X, Y) or Bubble Chart button in Excel 2013)> Scatter. See screen shot below:
Step2: Right click the blank chart, and select the Select Data from the right-clicking menu.
Step 3: In the opening Select Data Source dialog box, click the Add button. Then in the Edit Series dialog box,
![Membuat Membuat](/uploads/1/2/5/7/125714816/181096143.jpg)
(1) In the Series name box enter a name for this series, such as Timeline;
(2) Specify the Range F2:F14 in Axis column as the X values in the Series X values box;
(3) Specify the Range E2:E14 in Height column as the Y values in the Series Y values box;
(4) Click both OK buttons to close two dialog boxes.
Step 4: Add error bars for the scatter chart:
- In Excel 2013, select the scatter chart, and click the Design > Add Chart Element > Error Bars > More Error Bars Options;
- In Excel 2007 and 2010, select the scatter chat, and click the Layout > Error Bars > More Error Bars Options.
Step 5: In the coming Format Error Bars dialog box/pane, click the Vertical error bar tab, and check the Minus option, No Cap option, and Percentage option, and specify 100% in the percentage box. Then close the dialog box or pane.
Step 6: Go to the scatter chart, click any horizontal line at the top of error bars, and press the Delete key.
Step 7: Right click any data point, and select the Add Data Labels from the right-clicking menu.
Next click one data label twice, and in the formula bar enter =, select the corresponding label in the Label column, and press the Enter key. And repeat this step to change each data point’s label one by one.
Step 8: Click one data point twice, right click and select the Format Data Point from the right-clicking menu.
Step 9: Add a picture or photo for selected data point:
- In Excel 2013’s Format Data Point pane, click the Fill & Line tab > Marker > Marker Options > Built-in, then click the Type box and specify the image icon from the drop down list;
- In Excel 2010/2007’s Format Data Point dialog box, click the Marker Options tab > Built-in, then click the Type box and specify the image icon from the drop down list.
Step 10: In the opening Insert Picture dialog box, find out the image or photo you will add for selected data point, and click the Insert button.
Notes:
(1) We can’t adjust the image size after inserting into chart, as a result, we have to prepare the images in proper size before the step 9.
(2) We can also insert an image by this way: select the scatter chart, click Insert > Picture and find out a corresponding image, and then resize and move this image in the chart.
Step 11: Repeat the Step 8 – Step 10 to add images for each data point one by one, and then close the Format Data Point dialog box/pane.
Part 3: Save the timeline/milestone chart as a template in Excel
This part will show you how to save the timeline chart as a chart template in Excel easily.
Step 1: Save the timeline/milestone chart as a chart template:
- In Excel 2013, right click the timeline chart, and select the Save as Template from the right-clicking menu.
- In Excel 2007 and 2010, click the timeline chart to activate the Chart Tools, and then click the Design > Save As Template.
Step 2: In the popping up Save Chart Template dialog box, enter a name for your template in the File name box, and click the Save button.
Related articles:
Kutools for Excel - The Best Office Productivity Tool Increase Your Productivity by80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Works with Office 2007-2019 and 365. Supports all languages. Easy deploying in company. Full features 60-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.