EXCEL GRAPHING HELP: SEMI-LOG Graphing   

Enter Data

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

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".