Calculations / Formulas in data sheet

[Erwin Fischer]

Is there a way to apply formulas to the datasheet? (For example, we have a
graph with multiple rows and columns, and want to sum each column for all
series, creating a master "TOTAL" series that I could create a trend line
against (and then hide the series from displaying) - so that I can get a
total trend line. If there's a way of doing this with a stacked column type,
it would be ideal (is possible under Harvard and Presentations). Harvard and
Presentations (Corel) also have complete formulas available for application
against rows or columns of the data sheets.

Please help - I'm sure there's GOT to be a way of doing this.

[Tara Byers]

Hi Erwin,

When I want to do formulas in my charts - I use the Insert - Object -
Microsoft Excel Chart option. This gives me the graph but also the sheet
(Sheet1) the data comes from and it is from Excel so you can add any formula
you like.

Tara Byers
Payne Consulting Group, Inc.
visit us at: www.payneconsulting.com

Erwin Fischer wrote in message
<#cN7jbtR...@uppssnewspub04.moswest.msn.net>...