Hi All

I am using MSgraph to show graphs in a form. Up to now I have copied a single record to display, for example a stock record with the desc, and jan - Dec sales figures in serparate fields . When I save it as a excel file , the first row shows each month across while the second row shows each months sales under the correct month. This works really well. However, I would now like to be able to use the same format , this time filling in stock categories on the first row of the excel file and the coresponding sales figures on the next row. I am trying to do this form a fiel that's structure is

category
sales

Hopefully you can understand where I am coming from. Is there a way of filling this file maybe from variables ?

Thanks
Brian