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.

You can use an area chart to plot a single line and shaded area, but most area charts plot multiple lines (data series) so you can break down the trend between groups compared to the whole.