How to Plot Multiple charts using Macro

[kentck86]

Hi all,

I would like to generate a macro which can work on by importing an excel tabulated datas and plot it into several graphs in one click and added with a filter function would be best.

Here i link one of the sample of macro for this :

http://www.4shared.com/file/aoGHljU7/3G_Hourly_Performance_SPDH_1_0.html

Anyone can advise me on this please?

thank you

 

[Worf]

It appears that we must join 4shared.com to download the file...

 

[kentck86]

It appears that we must join 4shared.com to download the file...

Hi,

try this link please:

http://www.sendspace.com/file/xiryxy

thank you

 

[Worf]

Hi
I downloaded your workbook and saw the charts, but the VBA project is password protected...

Could you explain your goal in more detail?

 

[kentck86]

Hi
I downloaded your workbook and saw the charts, but the VBA project is password protected...

Could you explain your goal in more detail?

Hi,

My goal is to import the statistic datas and plot it into charts, charts are to be plotted base on the title or date i key in.

thank you

 

[Worf]

Hello again</SPAN></SPAN>

Before writing some code, I would like to ask you this:</SPAN></SPAN>

• What is the input method to key in title or date? Sheet cell, input box, user form?</SPAN></SPAN></SPAN>
• What will be the relationship between input date and plotted charts?</SPAN></SPAN></SPAN>