7. Customize your graph by adding titles, labels, and other elements using Excel’s chart formatting tools. Creating a semi-log graph in Excel follows a similar procedure, but with a few key ...

The answer is to use a semi-log plot. ... (7.04 and 4.46) such that they will easily fit in the same scale on a graph. But you don't have to actually take the log of the data.