In an Excel chart, how do I exclude a series from the data table?

I have a chart with 2 series and I want them both to show in the graph, but have only one of them show in the data table. Assuming it's possible, how do I do that?

Thanks,
John
LVL 1
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

AFAIK it's not possible, You will need to build your own datatable as a separate object

Regards
0
 
Danny ChildIT ManagerCommented:
Just hide that row?
0
 
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Hi Rgonzo, I'm sure you're about this. If I may ask, how do I build a separate table?   Thanks, John
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.