

VLOOKUP Range Lookup Table with Absolute References
Roman Kondratiuk
Where you choose to display diverse data in a chart, you can add and format a secondary vertical Y axis for clarity in presentation.
This may be best represented using a line chart.