title: How to hide a specific row of Excel chart data table?
body: <p>So right now I have a chart with 3 series, which will have 3 rows of data in the chart's data table. If I want to hide the last row in the data table, but keep the series in the chart, how can it be done? The only way I can think of is to create a block to cover that part, but is there a better way of doing it?</p>
  
  <p>Edit: I'm looking for a way to show the series in chart, but not in chart data table.</p>