Excel 2000 Data table assistance

[Havenstar]

Is it possible to have data appear on the chart but not all of the data to
appear on the data table - if so how?

 

[Jon Peltier]

The data table shows all the data in the chart. You can hide a charted series by
formatting the lines and markers or bars to be invisible, but you can't hide data
from the table.

You could construct a table in the cells near the chart (assuming it's embedded in
the worksheet), and include whatever data and formatting you want. Alternatively,
you can construct a table somewhere else, copy it as a picture (hold shift while
selecting the Edit menu, and choose Copy Picture, and use the Picture option, not
bitmap.

Tushar Mehta has a few suggestions about this on his web site:

http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

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

 

[Havenstar]

Thanks for the info Jon!

The data table shows all the data in the chart. You can hide a charted series by
formatting the lines and markers or bars to be invisible, but you can't hide data
from the table.

You could construct a table in the cells near the chart (assuming it's embedded in
the worksheet), and include whatever data and formatting you want. Alternatively,
you can construct a table somewhere else, copy it as a picture (hold shift while
selecting the Edit menu, and choose Copy Picture, and use the Picture option, not
bitmap.

Tushar Mehta has a few suggestions about this on his web site:

http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

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