Enter the text that you would like to see as the title. Click on the title and it will become editable. Choose a chart type, a chart layout, and a chart style, all of which are within easy reach on the Ribbon, a component of the new Microsoft Office Fluent user interface.
Now you should see a title appear at the top of the chart area. In Microsoft Office Excel 2007, it is easy to create professional-looking charts. Click on the Chart Title button in the Labels group and then select "Above Chart" from the drop down menu. To add a title, select the Layout tab under Chart Tools in the toolbar at the top of the screen ( Chart Tools will only appear when you have the chart selected). By default, your chart will be created without a title in Excel 2007. The axis values for each product are displayed on the left side of the graph.įinally, let's add a title for the line chart.
#CHART EXCEL 2007 TUTORIAL SERIES#
The blue series of data points represents the trend for Desktops, the red series of data points represents Laptops and the green series of data points represents Tablets. Now you will see the line chart appear in your spreadsheet showing the trend for 3 products (ie: Desktops, Laptops and Tablets). In this example, we have selected the fourth line chart (called Line with Markers) in the 2-D Line section. Click on the Line button in the Charts group and then select a chart from the drop down menu. Select the Insert tab in the toolbar at the top of the screen.
In this example, we have selected the range A1:D7. Highlight the data that you would like to use for the line chart. To create a line chart in Excel 2007, you will need to do the following steps: If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Create a Line Chart