Best Approach for Dynamic Charts (pivot table or OFFSET function?)

I have data we collect while drilling oil wells. It is based on depth, and then we plot a bunch of data such as geological grain sizes, sorting, tool data collected such as gamma counts, minerals and data on oil quallity. For the most part all this data is on one sheet in excel and the purpose of creating dynamic charts is so we dont constantly have to update the x axis (depth) and constantly update the source data for the charts. We usually only have to update the depth once per well but we have so many charts it would be nice if I could make this occur automatically. ie. if I could put the expected total depth of the well in one cell somewhere and it automatically updates all the x axis of all the charts. And then have the data we collect automatically plot as we add it to the worksheet.

Ive been playing around with both tables and offset function + ranges and have yet to figure out the best approach. Any advice would be appreciated.

By: Katie

1,539 thoughts on “Best Approach for Dynamic Charts (pivot table or OFFSET function?)

  1. HCG

    Very nice post. I just stumbled upon your blog and wished to say that I’ve really
    enjoyed browsing your blog posts. In any case I
    will be subscribing to your feed and I hope you write again soon!

  2. genolyze.com

    Spot on with this write-up, I absolutely feel this website needs far more attention. I’ll probably be returning to read more, thanks for the advice!

  3. udfauzi

    Can I simply just say what a relief to find an individual who truly knows what they’re talking about online. You definitely understand how to bring an issue to light and make it important. More and more people really need to check this out and understand this side of the story. I can’t believe you’re not more popular given that you definitely have the gift.

  4. moedah

    Hello there! I could have sworn I’ve been to this site before but after browsing through many of the articles I realized it’s new to me. Nonetheless, I’m certainly delighted I came across it and I’ll be bookmarking it and checking back frequently!

  5. poboleda.org

    After checking out a few of the articles on your web site, I truly like your technique of writing a blog. I saved it to my bookmark webpage list and will be checking back in the near future. Take a look at my web site too and let me know what you think.

  6. http://143.95.144.116/

    I was very pleased to find this site. I wanted to thank you for ones time for this wonderful read!! I definitely liked every part of it and I have you saved as a favorite to see new information in your blog.

  7. vivoslot

    Everything is very open with a clear clarification of the challenges. It was truly informative. Your site is very useful. Many thanks for sharing!

  8. Rich

    Excellent beat ! I wish to apprentice while you amend your
    website, how can i subscribe for a blog web site?
    The account helped me a appropriate deal. I were
    a little bit familiar of this your broadcast provided vivid clear concept

  9. vivoslot.net

    An outstanding share! I have just forwarded this onto a colleague who had been doing a little homework on this. And he in fact ordered me breakfast due to the fact that I discovered it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanks for spending some time to talk about this issue here on your website.

  10. yinga boy media

    I got this site from my buddy who shared with me concerning this website and
    at the moment this time I am visiting this web page and reading very informative articles at this
    time.

  11. dingdongtogel.com

    Spot on with this write-up, I honestly believe that this website needs a great deal more attention. I’ll probably be returning to read through more, thanks for the info!

  12. dingdong 24d

    Everything is very open with a very clear explanation of the issues. It was definitely informative. Your site is extremely helpful. Thank you for sharing!

  13. dingdong togel online

    After I originally commented I seem to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I recieve 4 emails with the exact same comment. Perhaps there is a way you are able to remove me from that service? Thanks!

  14. dingdong 36d

    I blog often and I truly thank you for your content. This great article has really peaked my interest. I will take a note of your website and keep checking for new information about once a week. I subscribed to your Feed too.

  15. keluaran hk

    Your style is so unique in comparison to other folks I’ve read stuff from. Thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this page.

  16. agen judi online

    I’m impressed, I must say. Seldom do I come across a blog that’s both equally educative and interesting, and without a doubt, you’ve hit the nail on the head. The problem is something that too few people are speaking intelligently about. Now i’m very happy that I found this during my search for something regarding this.

  17. dominoqq

    Oh my goodness! Awesome article dude! Thank you so much, However I am having problems with your RSS. I don’t understand the reason why I am unable to join it. Is there anybody else having similar RSS issues? Anyone who knows the solution will you kindly respond? Thanks!!

  18. agen judi online terpercaya

    Hi, I do think this is an excellent web site. I stumbledupon it 😉 I will revisit yet again since I book marked it. Money and freedom is the best way to change, may you be rich and continue to guide other people.

  19. Charolette Degroat

    I haven’t checked in here for some time because I thought it was getting boring, but the last few posts are good quality so I guess I’ll add you back to my daily bloglist. You deserve it my friend 🙂

  20. bandarqq

    Hi, I do believe this is a great website. I stumbledupon it 😉 I am going to return yet again since I book marked it. Money and freedom is the best way to change, may you be rich and continue to guide others.

  21. pengeluaran king4d

    Hello there! I simply would like to give you a huge thumbs up for the great information you have got here on this post. I will be coming back to your web site for more soon.

  22. game slot online uang asli

    This is the perfect webpage for anybody who wishes to understand this topic. You understand so much its almost hard to argue with you (not that I really will need to…HaHa). You certainly put a new spin on a subject which has been discussed for ages. Great stuff, just wonderful!

  23. sbobet mobile

    I wanted to thank you for this great read!! I absolutely enjoyed every bit of it. I have you saved as a favorite to look at new things you post…

  24. sbobet mobile

    I have to thank you for the efforts you’ve put in penning this blog. I’m hoping to check out the same high-grade blog posts by you in the future as well. In fact, your creative writing abilities has encouraged me to get my very own site now 😉

  25. credit repair

    You are so interesting! I don’t think I have read through anything like that before.
    So good to find someone with some unique
    thoughts on this issue. Really.. thanks for starting this up.
    This site is something that is needed on the internet, someone with a bit of
    originality!

Comments are closed.