Adding field to data label but not to chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mkk - 17 Feb 2004 17:54 GMT

Hi,

I am trying to add a column to the data table but not to the chart? I
that possible?

Thanks for the help.
M

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Nicky - 18 Feb 2004 04:05 GMT

I don't think so, but you can achieve much the same effect by hiding th
series you don't want in the chart (eg set line colour to none in
line chart, line and fill to none in a column chart) and deleting th
reference to the series from the legend.

The attached shows an exampl

Attachment filename: hidden series.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44590
--
Message posted from http://www.ExcelForum.com

Reply to this Message

Debra Dalgleish - 18 Feb 2004 11:56 GMT

Add the series to the chart.
Select the series you want to hide, and choose the
Line Chart type from the Chart toolbar.
Choose Format>Selected Data Series, and set the Line and Marker to None.
To remove the series from the legend, click on the legend to select it.
Click on the series label in the legend, and press Delete.

> I am trying to add a column to the data table but not to the chart? Is
> that possible?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

mkk - 18 Feb 2004 15:14 GMT

thanks!

---
Message posted from http://www.ExcelForum.com/

Reply to this Message