Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BasV
 
Posts: n/a
Default 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
  #2   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
BasV
 
Posts: n/a
Default

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   Report Post  
bj
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph with pivot table Richard Vajsar Excel Discussion (Misc queries) 1 July 18th 05 11:04 PM
How do I create a combination graph with stackedColumns+lineGraph ChartQuestion Charts and Charting in Excel 1 June 14th 05 12:39 PM
Graph Help- 12 month graph, but only want months that have passed coal_miner Charts and Charting in Excel 4 June 3rd 05 03:03 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"