The second part is easy: format the data series to have no Line and no
Makers
I know of no way to achieve the first part
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/o...ult.aspx#tab=4

"Legends" wrote in message
...
Any way to show series A - D in the graph and not on the data table and
series E-H on the data table and not on the graph?