Chart - Plot Series but don't include data in Data Table.

Hi,

I have a simple chart with one series plotted as columns and the other series (the median of the first series) plotted as a line.

The chart has the data table shown underneath and I'd like to remove the median value from the data table whilst still retaining the chart line plot in the body of the chart.

Anybody got any suggestions, or a work around to achieve the same short of just displaying the data labels in the plot area?

Usual TIA

Data Tables are useless. I'd use the Camera tool to take a snapshot of the cells you do want displayed.

As R. says the chart table is very very limited in what you can do in terms of content and formatting.

Some info here,
http://tushar-mehta.com/excel/newsgr...able/index.htm

Thanks Andy - and R.

I thought it was a forlorn hope but grateful for the input.

Rgds