ExcelBanter - Data table in a graph

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data table in a graph (https://www.excelbanter.com/excel-discussion-misc-queries/94935-data-table-graph.html)

JimP

Data table in a graph

Is it possible to show a series in a data table in a graph, and not show
(hide) the series in the graph?

SAR

Data table in a graph

Plot your chart with data table. Go to the chart, right click on the
individual series you do not want to show, choose "Format Data Series",
change border to "none" and area to "none". The hidden series still
appears in the data table.

--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=553595

All times are GMT +1. The time now is 05:09 AM.