extra cellreference in graph
 

How can I add extra cellreference in a graph?
I have a normal graph and want to add somewhere in the white area a
cellreference.
anybody ?

greetings
BasV

I am not completely sure what you want, but heres a try
setting up an empty text box, click in the formula bar and enter = and
select your cell

"BasV" wrote:

How can I add extra cellreference in a graph?
I have a normal graph and want to add somewhere in the white area a
cellreference.
anybody ?

greetings
BasV

I have a graph with horizontal the weeknumbers and vertical the weekamount
Two lines: the weekamount and the average(total weekamount div by weeks)

I want to add only the total weekamount (the sum of all the
weekamounts)somewhere in the sheet, so that when I print the graph, all the
information I need is shown.



"bj" wrote:

I am not completely sure what you want, but heres a try
setting up an empty text box, click in the formula bar and enter = and
select your cell

"BasV" wrote:

How can I add extra cellreference in a graph?
I have a normal graph and want to add somewhere in the white area a
cellreference.
anybody ?

greetings
BasV

do you want the data to be another chart entry (another line or a bar or a
column) or a text value?


"BasV" wrote:

I have a graph with horizontal the weeknumbers and vertical the weekamount
Two lines: the weekamount and the average(total weekamount div by weeks)

I want to add only the total weekamount (the sum of all the
weekamounts)somewhere in the sheet, so that when I print the graph, all the
information I need is shown.



"bj" wrote:

I am not completely sure what you want, but heres a try
setting up an empty text box, click in the formula bar and enter = and
select your cell

"BasV" wrote:

How can I add extra cellreference in a graph?
I have a normal graph and want to add somewhere in the white area a
cellreference.
anybody ?

greetings
BasV