Friday, July 15, 2011

How to Make a Linear Vs. Logarithmic Chart


1. Click on the Excel logo on your desktop to open Excel.
2. Click on a cell in a new Excel document and type in the first of your data points. Press the enter key and enter the second data point in the cell below. Repeat this until you have entered all your data points.
3. Click on the first cell in your column of data and then drag down, keeping the left mouse button pressed, until you have highlighted your entire column of data.
4. Click on the 'Insert' tab in Excel and then click the 'Line' button in the charts section of the ribbon. A menu should appear.
5. Click on one of the 2-D chart styles in the menu. A chart will appear in Excel.
6. Click on the row of numbers running down the left-hand side of the chart. Right-click and select 'Format Axis.' The Format Axis menu will appear.
7. Click on the 'Axis Options' tab of the Format Axis menu. Click on the tick box next to 'Logarithmic scale'.

Blogger news