Excel Chart help

[gill123]

Hi,

I need your guys help with this excel data. I need to create a chart that will show sales for 4 shops for past 3 years. Since one of the Shops sales are huge in $ compare to others, I am having hard time displaying the best chart. Someone also told me try panel chart, but I am not sure how to even do that. I found panel chart instruction on google but my chart just doesn't look right. I have attaché the excel file.

Thank you guys!

[MrShorty]

I think it might have helped us understand what you are having trouble with if you had included some of these "failed" attempts.

A panel chart does seem like one possible idea. Whose instructions did you find on google? Here are the instructions I usually suggest: http://peltiertech.com/Excel/Charts/StackedCharts.html