How to Make a Linear Log Graph in Excel

1. Open Excel 2010 and open your spreadsheet containing the logarithmic data set.
2. Locate an empty space in your spreadsheet to work on your chart. Click somewhere in this area. Click on the 'Insert' tab in the top menu. Click on 'Scatter' in the 'Charts' section and select 'Scatter with Straight Lines and Markers.' Putting your mouse over each icon will give you the title.
3. Right click in the blank chart area that appears in your spreadsheet and click 'Select Data.'
4. Click on the icon at the far right of the 'Chart data range' text box use your mouse to click-drag select the rows and columns containing your data for this chart. Click on the icon again at the far right of 'Chart data range' so that the 'OK' button is displayed. Click 'OK.'
5. Double click on whatever axis (x or y) is your logarithmic data range. For instance if it is the x axis, Double click on the numbers on the x-axis scale. Click on the 'Logarithmic scale' check box which is in the 'Axis Options' section. Click the 'Close' button. You will now see your selected axis changed in scale, for instance increments in base 10 are 1, 10, 100, 1000, etc.
6. Click the 'File' tab in the top menu and select 'Save As' to save this file to keep your work.