With the chart selected, click Chart Tools > Design > Chart Layouts > Layout 1 (the first option).Īlso, we need to give the chart a title and label the y-axis. The x-axis labels displaying the months looks a little cramped, so let’s display them at an angle. I selected Line with Markers to produce this line chart:īecause we selected the column headings, they appear in the chart’s legend to the right. Click Insert > Charts > Line, and select a chart type. To create a line chart, select all the data and the column headings. Notice that the “timeline” has been entered into the left hand column while each data series (for each region) has been entered into subsequent columns. Here we have a spreadsheet containing sales figures by month for three different regions: the North, Midlands and South. Also, you might want to use a scatter chart if you have more than ten numeric labels. If you have only one series, you should consider using a scatter chart. Line charts are especially useful for displaying multiple series. You should use a line chart if your category labels are text, and represent evenly spaced values such as days, months, quarters, or years. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. In Excel 2010, line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |