Dynamic Graphs

**twalker1228** · 02-27-2013, 07:08 PM

I am trying to setup a graph to dynamically build based off data that is constantly changing or being added/removed and not sure how to do this.

See attached file for example.

**jeffreybrown** · 02-27-2013, 07:30 PM

See http://peltiertech.com/Excel/Charts/...umnChart1.html

**twalker1228** · 02-27-2013, 07:35 PM

I have tried using this approach, but it doesn't work properly. Any other ideas?

**jeffreybrown** · 02-27-2013, 07:43 PM

Highlight the entire set of data, B2:H6 then turn the data into a table.

Select Ctrl + T >> Check My table has headers >> OK

Now enter a new column label in I2 and then the associated data in I3:I6

**twalker1228** · 02-27-2013, 07:48 PM

OK, I did all that, now how do I get my graph to auto-update with that new data

**twalker1228** · 02-27-2013, 07:49 PM

Nevermind, I got it, Thank you!

**twalker1228** · 02-27-2013, 08:18 PM

I have ran into an issue, in my report that I am using; there are formulas and not static data. Any other ideas?

**jeffreybrown** · 02-27-2013, 11:03 PM

Please attach an example that represents your actual setup and the issue you ran into.

**twalker1228** · 03-07-2013, 07:38 PM

Here is a sample file with formulas for what I want the graph to build based off of what the data pulls

**benishiryo** · 03-07-2013, 11:45 PM

hi twalker1228, seems to be a similar problem here:
http://www.excelforum.com/excel-prog...ed-ranges.html

difference is your number of rows is fixed i guess? my solution there would work for you. change it to:
=OFFSET($C$3,0,0,1,COUNT($3:$3))
this is for "High". change the one in red to 1 to 3 for "Close", "Score" & "Open"