ExcelBanter - Data Table Label

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

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

- - Data Table Label (https://www.excelbanter.com/charts-charting-excel/116534-data-table-label.html)

Whitfill

Data Table Label

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
--
Whitfill
Collective Technologies
Austin, TX

Jon Peltier

Data Table Label

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
_______

"Whitfill" (donotspam) wrote in message
...
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
--
Whitfill
Collective Technologies
Austin, TX

Whitfill

Data Table Label

That works quite well - thank you!
--
Whitfill
Collective Technologies
Austin, TX

"Jon Peltier" wrote:

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
_______

"Whitfill" (donotspam) wrote in message
...
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
--
Whitfill
Collective Technologies
Austin, TX

FloMM2

Data Table Label

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.

"Whitfill" wrote:

That works quite well - thank you!
--
Whitfill
Collective Technologies
Austin, TX

"Jon Peltier" wrote:

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
_______

"Whitfill" (donotspam) wrote in message
...
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
--
Whitfill
Collective Technologies
Austin, TX

All times are GMT +1. The time now is 03:12 AM.