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.
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.
HTH
Regards, Jeff
I have tried using this approach, but it doesn't work properly. Any other ideas?
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
OK, I did all that, now how do I get my graph to auto-update with that new data
Nevermind, I got it, Thank you!
I have ran into an issue, in my report that I am using; there are formulas and not static data. Any other ideas?
Please attach an example that represents your actual setup and the issue you ran into.
Here is a sample file with formulas for what I want the graph to build based off of what the data pulls
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"
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks