2

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?

1
  • I am afraid what you ask for cannot be achieved. :( Dec 13, 2020 at 22:18

1 Answer 1

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.