Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graph with pivot table | Excel Discussion (Misc queries) | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) |