ExcelBanter - Showing values in data charts not in any series

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Showing values in data charts not in any series (https://www.excelbanter.com/charts-charting-excel/246138-showing-values-data-charts-not-any-series.html)

SJChizar

Showing values in data charts not in any series

Is there anyway I can display values from a spreadsheet not used in the chart
in a data table?

Jon Peltier[_2_]

Showing values in data charts not in any series

The data table shows all data in a chart, and only data in the chart.

Plot the data, but hide the series (no lines or markers, no border or fill).

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

SJChizar wrote:
Is there anyway I can display values from a spreadsheet not used in the chart
in a data table?

All times are GMT +1. The time now is 04:26 AM.