I won't be able to look at this closer until later. Are there specific parts of Peltier's tutorials that you have difficulty implementing? I would expect:
1) In a convenient place in the spreadsheet, enter a column of 0s (X values for new, xy scatter data series), a column for the desired data label values, and a column with the desired logarithm of those values (LOG() function -- y values for new, xy scatter data series).
2) Go into the Select data dialog and add a new data series, use the column of new y values for the values.
3) Change this new data series to an xy scatter chart type (to create the line + xy scatter combination chart). Excel may automatically add secondary vertical and horizontal axes.
4) From Select Data dialog, edit the new data series to use the correct x values for this data series (the column of 0s from step 1).
5) Come up with a workable combination of scale on the secondary horizontal axis and value in the x values that correctly positions the xy scatter data series on top of the primary vertical axis.
6) Add data labels (values from cells option) to the xy scatter data series and tell it to use the data label values column from step 1.
Bookmarks