Thank you.

Should I create an array to store data and then use "=" to put data inside .Row, .Column and .Data?

Could you tell me the command to make the data to a bar chart, please?

many thanks

Sunny

>...method name of input array to cell, please?
>
>many thanks
>
>

---

>Use the following properties of MS Chart Control to handle data:
>

.Column   && Set/Get Current cell collumn
>.Row   && Set/Get Current cell row
>.Data  && Set/Get Data for the Current cell
>

>
>HTH