With your chart selected, access the Chart Tools Design contextual tab of the Ribbon as shown highlighted in red within Figure 2, below. Line charts can also be combined with bar charts in order to compare two.Now, what if we want to change this order to apples, grapes, and bananas without bringing up the Excel data? Yes, we can make these changes within PowerPoint.To start with, you need a chart inserted and selected within PowerPoint 2013 for Windows as shown in Figure 1, above. This example uses a combo chart based on a column chart to plotFigure 1: Initial position of the Chart Data SeriesClick on excel File type available on Connect Pane and the select your file. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of 500 per day. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. The vertical axis of this chart contains percentage figures and not absolute value For example, if you want to show the percentage of contributions for the North & South sales over the last 5 years then this is the chart for you.Our Data Series within the sample chart below are grapes, apples, and bananas, and these show up in exactly the same order within the chart, as shown highlighted in red within Figure 1, below.You can change the size of the units on a chart axis their interval where they start where they finish and more Sections Change Vertical Axis Units Change.Combo charts combine more than one Excel chart type in the same chart.In Figure 3, the Move Up button is greyed out because the selected Data Series (Grapes) is already at the top position within the Data Series list highlighted in blue within Figure 3, and thus can go no higher. These buttons are used to change the order of the chart Data Series. Within this dialog box, you can see the Move Up and Move Down buttons as shown highlighted in red within Figure 3, below. This will summon the Select Data Source dialog box, as shown in Figure 3.As and when you click these buttons, you can see the changes happening within the selected chart simultaneously. If you want to move it downwards, click the Move Down button. If you want to move the selected Data Series upwards, then click the Move Up button. You can also see that the Move Up button is now active (highlighted in blue within Figure 3), since the selected Data Series 'Apples' is in the middle position and it can be moved either up or down. In Figure 4 you can see that we have selected the second Data Series named 'Apples' (highlighted in red within Figure 4).
![]() In Figure 6 you can see that the 'Apples' Series has moved to the first position which is indicated within the Legend, highlighted in red within Figure 6 (compare to Figure 1, shown earlier on this page). Once you have reordered the Series as required, click the OK button, highlighted in blue within Figure 5, above. In Figure 5 you can see that the 'Apples' Series has moved to the top within the Data Series list as shown highlighted in red within Figure 5, below.
0 Comments
Leave a Reply. |
Details
AuthorJulie ArchivesCategories |