If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.