I don’t know if it helps, but the result= two dependances, is exactly the same, as the excel (I use the 2007 version) makes a default graph from two columns throught a “macro”. The second thing is, the edit button in ‘category’ is not highlighted, so I can’t edit the x-axis data. I have a question, but first: you have a super video on this side ,īut the question is: I tried to make my “XY” chart make dynamic by the offset formula and I encountered this problem: I came to the point, where I made the name ranges, and then when I highlight the data (including the x-axis(as you named it in your video) range) and make a XY chart, it makes no xy dependance but two dependances(“X” and “Y” as a function of the x-axis range). Sorry that I’m writing this way, but I want this comment calmly public… I wanted a to write a question in an editable window, where I can edit my text to be more expressible, or where I can insert code from my excel macro, or paste a picture of my chart to be more helpful, but this is probably not a forum-like ask-support… :-/, never mind… Oh well, if we must use the offset function in our Excel graph, then lets get to it. (You can also see this technique demonstrated in the Video below) How-to Make Dynamic Excel Dashboard Charts Using Tables You can read all about it on this post and it also has a video as well. This easier solutions involves using Excel Tables. It may not work as easily for Excel 2003, so you may want to stick with the Offset technique for that Excel Version. If you are using Excel 2007, Excel 2010 or the New Excel 2013 you can use this technique. In fact, I would offer up an alternate and MUCH MUCH EASIER solution then using the Offset formula in Excel to create a Dynamic Chart. Here is what it looks like:Īfter looking at the data, it didn’t seem too complicated. I had joined an excel forum and one of the members just did it for me but I have no idea how he did it so was struggling with it.” I have added some dummy data to create a graph but I’m not very familiar with the offset function itself. “I’m creating a social media benchmark tool using Excel, and I need to create a pre set graph which will update itself as I add/remove/edit data. However, Mili and a few other of the video viewers wanted to see how to use the Offset Function to create the dynamic graph for their Excel Dashboard in the same video.Ĭase Study – Create a Dynamic Chart in Excel using the Offset Function: You can check out these posts and videos here: Find the Last Row or Last Column for Dynamic Excel Dashboards This is the Bomb: or How I came to love the Offset function Namely, how to find the last row and also how to use the offset formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |