Plot your chart with data table. Go to the chart, right click on the
individual series you do not want to show, choose "Format Data Series",
change border to "none" and area to "none". The hidden series still
appears in the data table.


--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=553595