| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Hybrid Mode
