How to retain graph from report



Hi,

I am able to successfully generate graph in a report based on some x
and y values and show the raw data on this report as well. I have
since applied a macro that exports this report into Excel. However, it
does not retain the graph that was generated in the report. I know I
know, as long as it exports the raw data, I should be able to make my
own graph in Excel but people are busy and they would want this fully
automated. How can I have Excel or Acess regernate this graph
automatically when raw data is opened in Excel? Any suggestions?

S

.



Relevant Pages

  • Re: Automatically retrieve data from excel
    ... Excel file to populate this report automatically. ... the graph will update from the Excel data whenever the graph is ... Steve Rindsberg, PPT MVP ...
    (microsoft.public.powerpoint)
  • Re: How to retain graph from report
    ... columns then you can create an XL template file and export the data to that ... I am able to successfully generate graph in a report based on some x ... since applied a macro that exports this report into Excel. ...
    (microsoft.public.access.reports)
  • Re: Need help getting started
    ... very little solid protection offered inherently by Excel. ... Excel is an end user tool - not a development environment. ... >>> The exported data will reside in an Excel file as raw data in a couple ... >>> The thing I'm not sure about is how users should activate the "report ...
    (microsoft.public.excel.programming)
  • Need help getting started
    ... The exported data will reside in an Excel file as raw data in a couple ... The thing I'm not sure about is how users should activate the "report ...
    (microsoft.public.excel.programming)
  • Export out a project to Excel from MS Project
    ... I am a newbie of MS project and was asked to make a report and export it ... that I can't export it out to Excel. ... have total workload of each person by month. ... report out to Excel (raw data) and we then can edit it. ...
    (microsoft.public.project)

Quantcast