View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default VBA Code to Export Data from Chart

Cognos Impromptu?
I don't work with it directly myself, but our accounting department uses it
to extract data from databases. Don't know that they build any charts with
it. But... since data for a chart must becoming from a query somewhere,
couldn't you create a query or to provide the data that's being used to make
the chart as a table and then export the table to Excel?

"Curt J" wrote:

I have a chart that is automatically produced from Cognos. I export the data
into Excel, but the data for X and Y axis is contained in the chart. How do
I export that data into a spreedsheet?