Sunday, August 28, 2011

How to Plot a Time vs. Growth Graph in Excel 2007


1. Open Microsoft Excel 2007.
2. Place all the 'Time' values in one column, for example, column A. Place all the 'Growth' values in an adjacent column, column B. The 'Time' values become the x-axis values while the 'Growth' values are the y-axis values.
3. Click the first cell included then drag your mouse towards the last included cell to select the range of values to be included.
4. Click the 'Insert' tab from the menu bar. Go to the 'Charts' menu and click 'Scatter.'
5. Click 'Chart Area' to display the 'Chart Tools,' 'Design,' 'Layout' and 'Format' tabs.
6. Go to the 'Design' tab and select the style you want to use.
7. Type the main title for your chart under 'Chart Title.' For example, you can use 'Time vs. Growth' as the main title.
8. Click the 'Layout' tab and then click 'Axis Titles.' Select the 'Primary Horizontal Axis Title' and put 'Time' as the title for the x-axis. Click the 'Primary Vertical Axis Title' and put 'Growth' as the title for the y-axis.
9. Press 'Enter' to create the chart.

Blogger news