How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

This example uses a DATA step to generate data. The PROC PLOT step shows two plots of the same data -- one plot without a horizontal axis specification and one plot with a logarithmic scale specified ...

A dot plot is judged by its position along an axis; in this case, the horizontal or x axis. A bar chart is judged by the length of the bar. I don’t like using lengths with logarithmic scales.