Google Sheets – How to Overlay Two Charts

google sheetsgoogle-sheets-charts

In Google Sheets, I need two sets to data to appear on the same chart. One needs to be a scatter charts and the other needs to be a line chart. Both sets of data have the same x and y axis data / range. I just need to show both in a single chart using different chart types. How can this be done in Google Sheets?

Best Answer

Google does not have a feature to do what you want. However, a work-around may be possible by making the line transparent.

This is untested.

  • Create two graphs
  • Edit the Line graph to remove the background colour (Customize, Chart Style, Background color=none)
  • Drag one graph to physically overlay on the other.
  • Format each graph according to requirements.
Related Topic