In the case of a scatter plot, whether ... Dynamic charts in Excel. By doing this, the curves in the graph would change as and when you change the value of the data. Read: How to calculate ...

So, understand your requirements and select a suitable chart type. Read: How to create a Line Chart and Scatter Plot Graph in Excel? Once you are done filtering your data, you need to create a chart.