Hide the data label for a data table in a chart

K

Kathy

Excel is automatically adding a title or maybe it's called a data label
[shows in name box] to the line of date from the data table in my chart.
It's calling itself Series 1 and I can't figure out how to hide it. Help!
 
J

Jon Peltier

Kathy -

The data table includes the series name. You can change the default "Series 1" to
something more descriptive: choose Source Data from the Chart menu, click on the
Series tab, select the series from the list, and type a label in the Name box.

- 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

How to getting text labels to show up in scatter chart. 0
Excel 2010 Data Labels options not saving 0
Labeling on independently stacked line chart 0
change chart primary horizontal axis label or name 1
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Chart SERIES OFFSET 5
Excel 2003 - Chart Data Label positions 1
Hiding Zeros in Data Table 2

Top