table and chart in vba

[lezawang]

Hi
I want to create a table like the one below then fill it with random number and then draw a chart. All in VBA. Is the possible? I just want to learn this using VBA. I did it manually and then recorded the macro but it is too big to understand. Can the code be simple just to understand the steps? Thank you very much.

[TABLE="width: 500"]
<tbody>[TR]
[TD]item[/TD]
[TD]jan[/TD]
[TD]feb[/TD]
[TD]mar[/TD]
[/TR]
[TR]
[TD]tv[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]computer[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]printer[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

No the code cannot be made simpler.
It's very simple to do it manually. Select the data, click chart.

id pick an easier example to learn vba.