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.

item	jan	feb	mar
tv	-	-	-
computer	-	-	-
printer	-	-	-

<tbody>
</tbody>

 

[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.