Cells values automatically to be plotted in graph

Hello Friends

Please find the 2010 file attached file <Cells values to be plotted in graph sss 280515.xlsx>.

In the graph text `Value are for : 16' is written by using text box
We can make to another cell by using another formula <="Value are for : "&G1>
I want to value in Cell G1 automatically.

how to do this ?


thanks in advance

thilag
[/B]

If I understand you correctly, you want the text box on the chart to update automatically with "Value are for: ##"?

If so, just select your text box (so that the resize circles appear on the corners), click in your formula bar (where you type the formulas normally), enter and equals sign = and select cell P32. Press enter and your text box will now reference that cell

Yes, it is working perfect. But the texts `Value are for:' is gone and only displaying 16.

If there is any way to add the texts ?

Hello
Your workbook is set to Manual Calculation. So won't change values unless you calculate the sheet with F9. Set to Automatic in File > Options > Formulas. Also are your referencing P32 in you Text Box?

Thanks for the troubleshooting DBY, I was just about to reply with those.

@AranDG Sorry if I've butted in. Perhaps should have waited for you to come back. I'll give you a rep for your first fast and concise response to help.

Yes, it is working very fine, earlier i gave linkage to cell G1 to text box and try to add the texts "Value are for : ".

But now i added the cell P32 to Text Box.

thanks

thilag

Originally Posted by DBY

@AranDG Sorry if I've butted in. Perhaps should have waited for you to come back. I'll give you a rep for your first fast and concise response to help.

Not at all, saved me writing out the same stuff!