Dear Robert,
Tks anyway, as your earlier tips were very useful to me. I'm also trying frm my side.
Anyways FYI, I'm generating chart from a cursor which is generated run-time. In my application, I'm allowing user to generate their own queries by simply accepting a few values from them. And show them a runtime chart as well as contents of table.
>>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.
Regards
Shaishav