Excel Graph w/ Custom Table

[laurenh5516]

I have a graph with a table, but I want to customize what is in the table. I have 7 series that I have plotted and I want those in the table but I have also created a series in my data for the average which will be a solid line in the graph. Is there a way to remove the average series numbers on the table while keeping the line on the graph?

 

[Worf]

Here are some ideas:

https://www.exceldashboardtemplates.com/how-to-fake-an-excel-chart-data-table/

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