Create charts, graphs in Excel 2007

Select the entire table of data (including data and header), then go to the Insert tab, select the desired graph icon in the Charts group.


Continue the small triangle below the icon Column chart to pop-up the lists of corresponding column. Choose your favorite template, the chart will automatically appear quite intuitive with detailed captions, as well as column headers are automatically filled.


To change the chart type you just click on the current chart then choose a new chart type, it will automatically switch. The following chart is selected the new 3-D Bar.


To name the chart, go to the Layout group, click the small triangle below the icon and select Chart Title’s put position. Here I select Above Chart and enter its name.


To add a title for the horizontal axis (or vertical axis) on your chart on Chart Tools, click the Layout / Labels / Axis Titles and choose the desired type and enter the content.
Result:

No comments:

Post a Comment