Can you show data in a data table but not plot it on the chart?

I need to be able to include a total column in a data table on the stacked
chart I'm doing but not plot it on the chart itself. Is this possible and
how?

Armadillo,

Unfortunately you can't add totals to a chart-generated data table.
However, with a little formatting work you can create a data table with
worksheets cells. Please see this site for an example:

http://pubs.logicalexpressions.com/p...cle.asp?ID=509

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"Armadillo" wrote:

> I need to be able to include a total column in a data table on the stacked
> chart I'm doing but not plot it on the chart itself. Is this possible and
> how?

In general John's suggestion is best. However, if it's not a complicated
table, you could add the Total series to the chart, then format it so it
doesn't show (no line, no markers, no fill, nothing).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Armadillo wrote:

> I need to be able to include a total column in a data table on the stacked
> chart I'm doing but not plot it on the chart itself. Is this possible and
> how?