Pivot charts, in my opinion, are the greatest solution for your issue. However, to ensure that all categories have enough data before creating a line chart. Otherwise, you won't see lines for all categories. You don't have enough information for all the automobile models in your sample data.
I have used the following sample:
![enter image description here](https://i.stack.imgur.com/qd9lc.png)
After that, I inserted a pivot chart. While creating the pivot chart, I choose "Date" for Axis (Catagories) and "Model" for Legend (Series), and "Price" for Values. Like this:
![enter image description here](https://i.stack.imgur.com/yavqx.png)
By simply right-clicking the Excel default chart, I can now change the chart type to "Line Chart." And I obtained the following outcome:
![enter image description here](https://i.stack.imgur.com/IegTm.png)