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

John Carney
John Carney used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Danny ChildIT Manager

Commented:
Just hide that row?
Top Expert 2016
Commented:
Hi,

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

Regards
John CarneyReliability Business Tools Analyst II

Author

Commented:
Hi Rgonzo, I'm sure you're about this. If I may ask, how do I build a separate table?   Thanks, John

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial