Final answer:
John should create an embedded chart to view his monthly sales chart and data on the same worksheet.
Step-by-step explanation:
If John wants to view his monthly sales chart along with his data on the same worksheet, he should create an embedded chart.
An embedded chart is inserted directly into a worksheet, allowing John to view his sales data and chart in one cohesive view. He can easily update the chart based on new data entries or make changes to the chart formatting.
This type of chart provides a convenient way for John to analyze and present his sales data without switching between different worksheets.