Friday, March 11, 2011

How to Make an X Axis in Excel 2007


1. Open the spreadsheet with the data for which you wish to create a graph. Place all the X values in one column and the Y values in a second column. Each row should contain the matching values for both axes.
2. Click 'Insert' on the Menu bar and go to 'Chart.' Pick your desired picture and input the description of the graph in the box provided.
3. Move to Step 2 of the Chart Wizard to arrange the Chart Source Data. Highlight the columns and their respective headings and click 'Enter.' Choose the 'Series: in columns' button.
4. Go to Series tab and fill out the X and Y value fields. Check this area carefully to make sure that Excel 2007 correctly identifies the columns for the X and Y axes. Since you are creating an X axis, be sure that it contains the correct data for that column before hitting the 'Next' button.
5. Fill out all the other tabs in the next step for the titles of the axes as well as the legend and labels of the data.
6. Click on the next step of the chart wizard to select the position of the graph. You can choose to create the graph on a separate workbook sheet or on the same page.

Blogger news