Suppress series data-points in chart

D

Don Niall

Hi,

When creating a chart, is there anyway to include a series
of data-points in the data table - but do not include the
series in the actual chart?

Don-
 
J

Jon Peltier

Don -

Series in the chart must appear in the data table, and vice versa. But
you can hide the charted data with formatting (no marker, no line, no
fill), and you can hide an unwanted legend entry by clicking on the
legend, then clicking on the text of the one you don't want, then
pressing the Delete key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Series Name 5
Chart SERIES OFFSET 3
Overlaying 2 Data Series with Different Time (X) Axis 3
Not plot a data series in a chart but still display in data table 1
Numbering Data Points on Chart 2
User Selectable Series and Number of Series for Line Chart 2
Display Name of each Data Series 1
XY scatter plot with more than 32000 rows in Excel 2003 0

Top