Chart is not working properly

I have developed a chart on worksheet named "Chart_Miles". It uses source data from worksheet named "Miles_Driven". For some reason, chart displayed is wrong based on the source data.
Can anyone look at the attached worksheet and let me know why the chart is not working properly and what I can do to fix it?

BTW: Other graphs I made using the same approach in the same workbook do work. Why isn't this particular graph working?

Thanks

Kirk

It's taking the data from the average mpg sheet not the miles driven sheet

I redid the chart from scratch and got it to work.

I am still interested why the chart did not work properly if anyone wants to look at it.

Andy:

Yes, it is getting the x data from another worksheet but on all charts the X data is the same; therefore, it doesn't matter which dataset I use for the X data.

I just have to make sure I use the right Y data set.

Correct.......... I suspect that the MPG chart was copied and the Y source data was not changed but that's just a wild guess.