Thread: bar graph with varying items

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.

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" <BCullenward.1s0gb8_1121095183.1878@excelforum-nospam.com>
wrote in message
news:BCullenward.1s0gb8_1121095183.1878@excelforum-nospam.com...
|
| 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
|

I tried what you suggested, but was having problems getting it to work. I copied the formulas, changing the cells to match mine, but I think the problem is that I pull my data from a database and that data is manually entered.

So I'm back to square one.

I thank you for your assistance tho.