EXCEL GRAPHING HELP: SEMI-LOG Graphing   

 

Enter Data

(note this is not real data, just an example).

mm basepairs
10 23000
12 9400
14 6600
18 4400
25 2500

Highlight chart, select "CHART WIZARD"

Select "x-y scatter"

    click on the "custom types" tab

        scroll down and select "logarithmic"

OR JUST GRAPH NORMALLY AND AFTER YOUR FINISH, RIGHT CLICK ON THE Y AXIS, SELECT SCALES AND AT THE BOTTOM CHECK "LOGRITHMIC"

Select "NEXT"

    click on the "series tab"

    remove "series 1"

    click on the "category (x) labels" box (on the right side of the bar) looks like a square tile

    on the spreadsheet, highlight the x data values (in the example 1,5,10, 15, 25)

    click on the "box" of the chart wizard (looks like a square tile)

Select "NEXT"

    on the "gridline" tab, select major and minor grindlines

    on the "titles" tab, add the title and the axes informaion

Select "NEXT"

Select "Finish"

Select one data point on the graph

    Go to "Chart" on the top toolbar

        Select "Add Trendline", select "exponential".