Creating multiple separate line graphs at once

[Jithe]

​Hi,

I have about 400 SKUs and I would like to track the demand trend using the sales figures. Is it possible generate multiple separate line graphs for each SKU?

I'm aiming to get an output similar to the image below.

Table 1
[TABLE="class: grid, width: 550, align: left"]
<tbody>[TR]
[TD]ITEM_SIZE[/TD]
[TD]ITEM CODE (SKU)[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sept[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]200 X 1140 MM[/TD]
[TD]RC.TOM.000045.MA.AG[/TD]
[TD]0[/TD]
[TD]12[/TD]
[TD]15[/TD]
[TD]9[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]15[/TD]
[TD]22[/TD]
[TD]17[/TD]
[TD]10[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]200 X 1140 MM[/TD]
[TD]RC.TOM.000046.MA.AG[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]25[/TD]
[TD]36[/TD]
[TD]9[/TD]
[TD]22[/TD]
[TD]17[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]200 X 1140 MM[/TD]
[TD]RC.TOM.000047.MA.AG[/TD]
[TD]1[/TD]
[TD]9[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD]11[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]200 X 1140 MM[/TD]
[TD]RC.TOM.000048.MA.AG[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD]30[/TD]
[TD]17[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]200 X 1140 MM[/TD]
[TD]RC.TOM.000049.MA.AG[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]7[/TD]
[TD]12[/TD]
[TD]18[/TD]
[TD]16[/TD]
[TD]14[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]29[/TD]
[TD]36[/TD]
[/TR]
</tbody>[/TABLE]

Thank you

 

[SteveO59L]

I have done this in the past using data validation and vlookup()

 

[VBA Geek]

it is possible using VBA. the data in the table and that in the graphs does not match though, am i missing something? then I guess the red line is a trend line

you may also consider the use of sparklines as it would be much quicker to add

 

[Jithe]

Hi VBA Geek,

What you have done is exactly what I am looking for. The graphs don't match because I jumbled up values for the financial year, (actual values were larger). Also yes, the red line is the trend line. Could you please tell me the steps on how to do this using VBA?

Thank you.

 

[VBA Geek]

Hi VBA Geek,

What you have done is exactly what I am looking for. The graphs don't match because I jumbled up values for the financial year, (actual values were larger). Also yes, the red line is the trend line. Could you please tell me the steps on how to do this using VBA?

Thank you.

The image that I have posted includes sparklines which you can add very easily without the need of VBA. Are you happy with the sparklines or do you really want to add 400 charts?
You also have the option to add one dynamic chart which shows the line of the series that you select

 

[Jithe]

HI VBA Geek,

Actually I am required to show 400 charts on this occasion. I did attempt the sparklines, but my colleagues preferred the individual charts method.

Thank you

 

[Jithe]

Hi VBA Geek,

Actually on the contrary, sparklines will work too. Thank you so much for your support, I really appreciate it.

Regards