How to create multi chart beside the data?
 

I'm doing up a treand monitoring chart.
so i'll need charts beside the data .

I manually tried created 4. and it's too inefficient cus there are too many.


https://www.dropbox.com/s/jxmelf9ggu...readsheet.xlsx

Will appreciate if you can teach me how to create and what's the fundamental behind it.

Best regards!

How to create multi chart beside the data?
 

Terry,

Have you looked into Sparklines? If you have 2010, they are included on the Insert tab. If not, there is an Add In available for earlier versions of Excel. A quick Google search will turn up more info.

Ben

That's way easier! thanks!