>Dear Robert
>
>Thanks a lot, this one is a real help to my graphing project.
>
>However, i want to change the plot of my graph from rows to column and vice versa. And i found out that by using;
>
>graphObject.plotby=xlRow or xlColumn
>
>it shd change. But somehow I always got OLE error and not able to change the Plot of the graph. can you help me here? Am I missingout something??
>


I had the same problems when I was starting to create my Graphs. Since I was hard pressed for time, and needed to move on to the next part of the project, I just changed my data table to the other direction. This won't work if you are want to be able to change back and forth on the same graph. (It will but its not pretty at all.) If I get a chance to investigate later today I will.

Sorry I didn't have a better answer for you.