Chart for multiple product lines sales over multiple years

[AmandaLittle]

Hello I'm working on charting sales history for multiple brands over multiple years. What would be the best way to set up the data? Data in the attached file is fictional.

[#2 · Accepted solution]

@AmandaLittle 

It's hard to say without knowing of what you'd like to have as result, but in any case it's better to keep everything in one table. Please check sheet 'Data' in attached.

[#3]

Thank you Sergei. That works well.

[#4]

@AmandaLittle , you are welcome