Excel Charts

D

Don

Can functions or cell references be used in chart or graph titles & axis
blocks in the 2007 version of Excel? If so, how do you go about it?
 
D

Dan DeHaven

Unless someone has come up with a cool trick, the functionality in th
chart tool doesn't seem to allow it.

But, I know how to get around that. What you can do is create an
"drawing" item that allows text inside it (like a rectangle, square
oval, or text box) and you can link it to a cell. Then that cell ca
contain the formula that you want.

Here is how you do it, create one of the drawing items I mentione
above and select it. Then click in the formula bar and enter "=" and th
cell address that you want to reference (like A5) and press enter. The
in the cell that you referenced you can create any formula that you ca
think of and the drawing object will display that value, number, text o
whatever.

Next you can size and format the drawing item over your chart where yo
want it and it will dynamically update based on changes to the dat
based on the formula that you created.

Give it a try,

Dan

Blink1
 
D

Don

Dan,

Thanks very much for your response. I am unable to access formulas,
however, once I create and select the drawing element. I tried it with a
rectangle and text box; Excel 2007 wouldn't allow me to enter a cell
reference that it would interpret as anything but simple text. Any ideas?

Don
 
D

Dan DeHaven

Don,

I'm not sure what going on on your end? I've tested this and have used
it many times personally.

FYI, You can't reference *anything other than the cell address in the
text box formula*, but you can make the formula in the cell that is
referenced anything you like. Make sure you're doing this otherwise it
won't work as you've stated.

If you're sure you've done this correctly give me an example of a
formula that you’re trying to return in the text box and I'll test it
here.

In my reference cells I've used dozens of different functions and mixed
Values & Text and seem to have no trouble.

Dan
 
D

Don

Dan,

I mis-interpreted your "how-to" instructions earlier; it's working just how
you said that it should. Thank you very much! I really appreciate your help.

Don
 
D

Dan DeHaven

Don,

Great to hear!

If you come up with any cool uses of that, please be sure to let
everyone know. I know most people aren't familiar with the functionality
but could use it.

Cheers,

Dan
 
Top