In the Charts group click on the arrow at the bottom of the Pie button. This time we’re going to compare the sales for the members of the North Region sales team for the month of January 2011. Let’s look at a very different type of chart. This time, this is how the chart looks.Įxcel 2010 has used the data in the additional selected row and now the category axis is labeled with the month names. Now select the Insert tab, then click on the arrow at the bottom of the Line button in the Charts group and choose the first option again. This time, select the data we did before and in addition select part of the row above that shows the month names. You can add some of this information manually if you need to, but some of it can be done by a better selection of data. They’re just shown as numbers on the chart without any explanation. However, it doesn’t know what these numbers represent and it doesn’t know what the numbers on the y-axis (value axis or vertical axis) mean either. It has also treated the month numbers as the ones to use on the x-axis (category axis or horizontal axis). Choose the top left one, and a line chart is created.Īs you can see Excel 2010 has successfully worked out that “Armstrong, Bill” – which is in the first selected cell – is actually a good title for the chart. However, if you make a choice and decide later it wasn’t the right one it’s not a problem as you can easily change the type later. Based on the icon you can choose a line chart type. They are shown as small icons that give you an idea of what each will look like. This lists the available line charts (also called line graphs) that are available. Make that selection, select the Insert tab, then click on the arrow at the bottom of the Line button in the Charts group. Here I’ve selected Bill’s name and the twelve numbers corresponding to his monthly sales. The first thing to do is to select Bill’s figures. So, for example, you may want to show how Bill Armstrong’s sales figures for 2011 are looking. If you wanted to present a visual message about these sales figures you may want to show the sales for an individual, for a team, for a region or for the whole company. The numbers corresponding to the individual sales and the various totals are included, but it is not easy to see any underlying trends or message. Look at this worksheet of sales data for 2011. Recent versions of MS Excel have not only made this process easier, but have added powerful additional design and formatting features.Ī chart is a visual representation of some data. The ability to create informative and good looking charts is one of the great strengths of Excel 2010. Microsoft Visio 2010 – 9 Hours Video Training.Power Pivot, Power Query and DAX in Excel.Adobe Photoshop Elements 11 – 12 Hours Video Training Course.
#Make a line graph in excel 2011 for mac series
In this scenario, the third series does not display as a separate chart type by itself. For example, if you create a three-series chart in line format, turn one data series into a column chart and try to transform the third series into a doughnut chart, the result shows your first series as a line, the second as a column behind the line and all three series as a doughnut behind the other two data series.
0 kommentar(er)
