Help with graph

  • Thread starter Thread starter S
  • Start date Start date
S

S

I have cells with info in them (£ values), each set of cells has a name, say
J2 has mary smith in it.
I then use this info for a graph chart.
Is there a way to automatically get the name mary smith onto the graph
chart?
I know how to do this manually but is there a way for example =J2 and this
would do it for me?

thanks

--
 
Hi,

You do not say exactly where in the chart you want the name to appear.
But if you mean as a data label then nothing automatic, unless the name
is already defined as either the series name or category labels.
There is however a free addin that makes the assignment of cells to data
labels simple.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy
 
Back
Top