Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. -- BCullenward ------------------------------------------------------------------------ BCullenward's Profile: http://www.excelforum.com/member.php...o&userid=25106 View this thread: http://www.excelforum.com/showthread...hreadid=386135 |
#2
|
|||
|
|||
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 | |
#3
|
|||
|
|||
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. -- BCullenward ------------------------------------------------------------------------ BCullenward's Profile: http://www.excelforum.com/member.php...o&userid=25106 View this thread: http://www.excelforum.com/showthread...hreadid=386135 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
Graph Axes | Excel Discussion (Misc queries) |