Excel has a lot of of beautiful charts to display. Line charts are a great choice if you would like to display a time line with progress. In this post I will teach you how to create a simple line chart with monthly data. My first step is to select the data I want to chart in the spreadsheet. Then after I click the Insert tab I click the Line chart command and pick from the available choices. I can always change my mind later from the Design tab.
The Ribbon supports three chart tools contextual tabs (Design, Layout, and Format). I make the chart layout and chart styles choices from the Design tab. I make the shape fill and shape outline formats from the Format tab. I change the layout from the Layout tab. Examples include working with the legend, titles, labels, and gridlines.
A chart has many different objects. For example there is the plot area, chart area, series, legend, title, etc. The following screenshot shows my final formatting of each of the objects. I clicked on the chart space and then changed the shape oultline to green and increased its width fromt the weight button which is found from the shape outline drop down list. This line chart has markers, which you can format either with a right click-format data series or click the shape fill and shape outline buttons.
If you would like to practice making a line chart in Excel, download Colorado.xlsx.