How to hide a specific row of Excel chart data table?

Question

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?

Edit: I'm looking for a way to show the series in chart, but not in chart data table.

Answer 1

Select the last row of chart data and format the cell's displayed text/number as ;;;. If the chart data is dynamic, then the last row can be identified with something like,

=row()=match(1e99, A:A)

This would enable you to create a conditional formatting rule that applies the ;;; cell number format to the last row.