Re: Novice Question

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 07/14/04


Date: 14 Jul 2004 02:35:29 -0700


"Lisa" wrote ...

> I am pulling data from a database monthly.
> The data totals are what I'm using to populate a graph.
> Of course the rows of data that make up the totatls are
> subject to change each month, meaning some rows will no
> longer be reported on or additional rows of data may be
> added. What I would like to do is make life as simple as
> possible. I'd like to be able to run the data pull each
> month and refresh my excel template with the data, and
> have my graph be smart enough to go find the totals I need
> regardless of what row or column they end up sitting on in
> the excel document.

What about just fetching the totals from the database?

Jamie.

--


Relevant Pages

  • Re: graphing question - want to show total in datatable only
    ... I would not include the data table in the graph. ... subreport which would allow you to add report totals. ... Duane Hookom ... > Im trying to graph the results of a cross tab query in Access 2k3 and I ...
    (microsoft.public.access.reports)
  • Re: chart totals
    ... Or you can just add them manually in PPT. ... Echo http://www.echosvoice.com ... already did the totals by cutting the datasheet detail out of the MS graph ... Then I pasted back into MS graph. ...
    (microsoft.public.powerpoint)
  • Re: chart totals
    ... Are you saying I need to do the whole chart in excel or the totals. ... already did the totals by cutting the datasheet detail out of the MS graph ... Then I pasted back into MS graph. ...
    (microsoft.public.powerpoint)
  • Working Hours (formula & graph) - any elegant solution?
    ... and then totals for the month at the bottom of the page. ... but the graph is "skipping" from positive to negative ... elegant and could be confusing... ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Working Hours (formula & graph) - any elegant solution?
    ... To avoid the negative times ... and then totals for the month at the bottom of the page. ... but the graph is "skipping" from positive to negative ...
    (microsoft.public.excel.worksheet.functions)