Hi E,

I understand your concern about plotting a value of 0 on a logarithmic scale. Unfortunately, it is not possible to plot a value of 0 on a logarithmic scale as the logarithm of 0 is undefined. However, there are a few workarounds that you can try to display the 0 value on your chart.

One option is to use a small non-zero value instead of 0, such as 0.001 or 0.01. This will allow you to plot the data on a logarithmic scale and still display the important value at the start of your curve. You can label the axis to indicate that the value is not exactly 0.

Another option is to use a broken axis. This means that you can break the y-axis at a certain point, such as 0, and display the values below the break separately from the values above the break. This will allow you to display the 0 value on the chart without distorting the rest of the data.

To create a broken axis in Excel, you can follow these steps:

1. Select the chart and go to the Format tab in the Chart Tools section of the ribbon.
2. Click on the Axis dropdown menu and select the axis that you want to break (usually the y-axis).
3. Click on the Format Selection button at the bottom of the dropdown menu.
4. In the Format Axis pane that appears on the right side of the screen, scroll down to the Axis Options section and check the box next to "Axis breaks".
5. Set the Minimum and Maximum values for the axis below the break and above the break.
6. Adjust the spacing and formatting of the axis as needed.

I hope these options help you to display your data effectively. Let me know if you have any other questions or concerns.