MS EXCEL FOR MAC USING A CHART TEMPLATE SERIES

This is done from the Value (X) tab and requires you to: To do this, from the Value (Y) tab, go to Major Gridlines and select None from the dropdown menu.ДЄdding vertical lines to the chart will help you highlight the relative distance between milestones. You may also want to remove the horizontal lines from the graphic as they aren't really relevant to the timeline. To do the same, go to Axis в†’ Value (Y) and select None from the dropdown menu under Value Labels. Seeing that the numerical values from the vertical axis overlap some of the milestone titles and donвЂ™t add much to the overall meaning of the chart, we decided to remove them. We chose to change the font from Regular Helvetica Neue to Bold Helvetica and decrease it from 12 to 10 points. Select all the milestone labels (Shift + Click) and use the Font options within the Bubble Labels tab on the right. Next, you will need to make the label text more visible by adjusting its size and color. In our example, we kept the centered placement of the label, but selected None from the Time dropdown menu. Within the same tab, you can change the labels' position using the Location feature, or their date & time format from the Value Data Format section.

MS EXCEL FOR MAC USING A CHART TEMPLATE SERIES

Add bubble labels displaying the milestonesвЂ™ descriptions and due dates: From the Series tab, tick the boxes for Show Series Name and Values, making sure to select X from the dropdown menu, as shown in the picture below: Remove the legend: Go to the Chart tab and unselect the box for Legend under Chart Options. If you want to go with this suggestion, then you need to: A more efficient way to communicate your milestones' details is to have them displayed directly on their corresponding bubbles. Here, choose None from the Time dropdown menu under Value Labels.ДЄlthough the legend situated above the graphic gives information about the chart milestones, it may be hard to follow for the viewer.

If you want to remove the hours for a cleaner look, select the chart area and then go to Axis в†’ Value (X) in the Format pane on the right. In our case, we used the value 20 for all our milestones.ДЄfter adding all the project data, the resulting chart will look like this:ДЈ.В Format the graphic to optimize relevance and include key details.ДЄs you may have noticed, Pages has automatically added hours to the time series on the timelineвЂ™s horizontal axis. Lastly, in each milestone's Size column, enter a number like 10, 20, 30 to set the size of the corresponding bubble on the timeline. Bubbles that have smaller plotting numbers will be shown closer to the X axis, while those with bigger digits will be placed higher up on the chart. These numbers will act as plotting elements that set the milestone bubbles' vertical positioning on the chart. In the Y column of each milestone, on the same row of the milestone's due date, add a digit such as 1, 2, 3, or 4. Use the X column to enter the due dates for each milestone, as shown in the image below. Keep the milestone descriptions as short as possible as these will be later displayed on the graphic and you want them to be fully visible. List your projectвЂ™s key events ( milestones) in the first row, the one populated by default with the month name. In the Chart Data table that pops up, add your project data as follows: Pages will automatically generate a bubble chart that looks like the one in the image below:Дў.В Add your project data to the bubble chart.Д¬lick on the chart area and then on the Edit Chart Data button that appears. Go to Insert в†’ Chart and select 2D Bubble from the menu that pops up. Open Pages and select Blank Landscape from the template gallery to ensure you'll have enough room for your timeline. Add a 2D Bubble Chart to your Pages document. Follow the four steps below to manually create a timeline in Pages for Mac.

Ms excel for mac using a chart template