- Select the cells that you want to chart, including the column titles and the row labels. These cells will be the source data for the chart.
- Click the Insert tab
- In the Charts group, select the desired chart category (Column, for example).
- Select the desired chart type from the drop-down menu (Clustered Column, for example).
- The chart will appear in the worksheet.
Once a chart is selected, a contextual set of tabs appears to enable you to alter the chart “Design”, “Layout”, and “Format”. The “Layout” tab can be readily used to (among other things) enter a title for the chart, x-axis label, and y-axis label. You may also format any of the axis as you see fit.
Leave a Reply
You must be logged in to post a comment.