View Single Post
  #2   Report Post  
ScottO
 
Posts: n/a
Default

Go to http://www.oaltd.co.uk/Excel/Default.htm
and download Stephen Bullen's "FunChrt1.zip".
This file demonstrates how to set up a chart so that it automatically
includes new data as you type it in. The trick is to use defined names to
link the chart to the data, instead of absolute references. The defined
names use the OFFSET() and COUNT() functions to refer to the data.
It should give you exactly what you want.
Rgds,
ScottO

"BCullenward"
wrote in message
...
|
| I need assistance with making a bar graph. I link some cells from a
| database query, and the items it returns will vary from 0-20. How can
| I make my bar graph incorporate the dynamic item count automatically?
|
|
| It needs to have "real-time" access, a simple data refresh should
| incorporate all the changes. Once an item is added it will not be
| removed (until the next day) when the graph will be refreshed.
|
|
| --
| BCullenward
| ------------------------------------------------------------------------
| BCullenward's Profile:
http://www.excelforum.com/member.php...o&userid=25106
| View this thread: http://www.excelforum.com/showthread...hreadid=386135
|