In Google Sheets, create your chart.
Click the triangle in the upper right corner of your chart and select Publish.
Next, choose the Embed tab and copy the HTML code. You will first have to Publish your chart to make it public.
In a new WordPress post, choose the HTML tab and paste the code.
Choose the Visual tab to continue editing your post and adding more content. Your chart should appear.