Data Table Label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Whitfill - 28 Oct 2006 14:55 GMT

I have created a chart with a data table, and chose to show the data table
below the chart. How do I remove the label "Series 1" so it doesn't show
next to the numbers on the graph?

TIA

Signature

Whitfill
Collective Technologies
Austin, TX

Reply to this Message

Jon Peltier - 28 Oct 2006 15:21 GMT

Not very elegant, but you can hide it by replacing it with a space. Chart
menu > Source Data > Series tab, select the series, type a space character
in the Name box.

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

>I have created a chart with a data table, and chose to show the data table
> below the chart. How do I remove the label "Series 1" so it doesn't show
> next to the numbers on the graph?
>
> TIA

Reply to this Message

Whitfill - 28 Oct 2006 15:41 GMT

That works quite well - thank you!

Signature

Whitfill
Collective Technologies
Austin, TX

> Not very elegant, but you can hide it by replacing it with a space. Chart
> menu > Source Data > Series tab, select the series, type a space character
[quoted text clipped - 12 lines]
> >
> > TIA

Reply to this Message

FloMM2 - 28 Oct 2006 20:54 GMT

Whitfill,
Next time, On your Chart, right-click in the chart area, this will select it.
The pop-up window, select "Source Data".
The pop-up window, select "Series" tab.
Now you can label them or space out.

> That works quite well - thank you!
>
[quoted text clipped - 14 lines]
> > >
> > > TIA

Reply to this Message