a user of one of my databases wants a excel chart instead of the actual report. I can use the query to analyze the data with excel and create the chart but I can't find a way to import the chart so that the user can open. Can someone tell me how to do this? I looked in help and it doesn't tell me anything.
I believe the same chart control is used in Access as Excel.
Now I can think of no reason why that would not be the case but the whole reason I wrote code to create charts in Excel is because the object model just seemed easier to manipulate & more comprehensive.