How can I create a Chart in excel using VB? Particularly, i hope to know how to :
1. set its chart type to Bar and line ( co-exist on the same chart );
2. set the color of the bar and line in the chart ;
2. how to tell the chart object from where it should get it's data from in order to chart them.
Can anyone give a some sample codes on the above question?
Thanks you very much.
Desperately need help!!