3

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?

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

1 Answer 1

Reset to default
2

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.
Improve this answer

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.