Mass produce graphs

**elton.li** · 07-19-2010, 12:15 PM

I'm now having a table recording the sales of every single month of my different products.
Say, I have 100 products with their sales of every single month. How can I mass produce a line graph for each of my products? Simply put, I want 100 separate sales against period graphs for all my products.

Can anyone help? Appreciate if you could share your answer to that. Thanks!

**teylyn** · 07-19-2010, 07:23 PM

Hello elton.li,

you may want to look into dynamic charts. Start here: http://peltiertech.com/Excel/Charts/Dynamics.html

**elton.li** · 07-19-2010, 11:24 PM

Thanks teylyn.
Although the information is handy, seems does not have the thing I wanted.
I mean if there is a quick way to create 100 separate sales against period charts for my data set.

**teylyn** · 07-20-2010, 02:41 AM

Do you want to create sales? Or do you want to create chart based on existing sales data?
For the latter, we can help if you provide a data sample. For the former, you need marketing advice.

A little more information about what you want to achieve would certainly be beneficial.

**elton.li** · 07-20-2010, 02:53 AM

Hi teylon, I mean I wanted to creat separate sales charts for each of the products. Plus, I want to skip the months with blank cells.
Here's a part of the data i'm working on.
Thanks for helping out!

**teylyn** · 07-20-2010, 02:57 AM

Could you provide some information on the kind of chart you want to create? A sample chart, maybe?

We can play 20 questions, but it would be easier if you could voluntarily part with the necessary information.