Chart Labels

gbarclay2001 · May 14th, 2002, 08:24 AM

Hi all,

Is there a way that a user can enter a value in cell and have that value inserted as a label above a bar in a bar chart. The label is not the value of the actual bar and it's value can't be entered in advance.

Thanks for any ideas,

Greg

sann0638 · May 14th, 2002, 08:53 AM

Greg,
put a dummy value in for the label of the bar, then change the value when you know what the label should be.

Rgds,
Mike

gbarclay2001 · May 14th, 2002, 09:00 AM

Yeah that was the only thing I could think of. Looks like it'll have to do.

Cheers Mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:24 AM	#1
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Hi all, Is there a way that a user can enter a value in cell and have that value inserted as a label above a bar in a bar chart. The label is not the value of the actual bar and it's value can't be entered in advance. Thanks for any ideas, Greg

May 14th, 2002, 08:53 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Greg, put a dummy value in for the label of the bar, then change the value when you know what the label should be. Rgds, Mike

May 14th, 2002, 09:00 AM	#3
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Yeah that was the only thing I could think of. Looks like it'll have to do. Cheers Mike