• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Triangular Plot - Gas data plot

    Thanks for the help, it looks great!
  2. R

    Triangular Plot - Gas data plot

    Faseeh, First of all thanks a lot it looks great for starters. Please don't rush and take your time I'm not in a hurry at all :) For now the only would be that the triangle needs to be the same on all sides, that is, Equilateral with all angles 60 degrees. The scale needs to be 0 to 0.2...
  3. R

    Triangular Plot - Gas data plot

    No I did not see this yet, but I am having a look right now. Thanks for the link! I'm still hoping to get some help from the local Ninjas when they have time for it. No rush at all :) Thanks everyone! EDIT: just had a look and it's really good, but the scales I need are 0 to 0,2 (which...
  4. R

    Triangular Plot - Gas data plot

    @ Faseeh That looks good, yes thanks! No rush at all! the graph itself will be much more complicated, but for now I just need to find out how to make a triangular graph. Thanks a lot!
  5. R

    Triangular Plot - Gas data plot

    Hello, It's done. The problem was I initially shared with rapidshare and was getting a bunch of problems so I changed it and took a while to create the DropBox account. Thanks!
  6. R

    Triangular Plot - Gas data plot

    Hello, This time I have a question regarding how to plot a triangular graph on excel 2010. I have uploaded two files on dropbox: DropBox Link: https://www.dropbox.com/sh/39uehxg6hngimsx/D60S6Sa0HA One file is an excel file I downloaded from the internet, it was a template for anyone who...
  7. R

    Histogram Like Line in charts [SOLVED]

    @ Chandoo: Thanks for that! It's always good to have more than one way to do things. Thanks!
  8. R

    Histogram Like Line in charts [SOLVED]

    Thats exactly what I wanted!!!! So I guess the trick to it was using this OFFSET function? Thank You!!!
  9. R

    Histogram Like Line in charts [SOLVED]

    OK I made up a file just for the example itself as the original one contains confidential data. Column A is Y Axis and column B is X Axis. X Axis is supposed to be the red line in the Picture I uploaded before, the line that I actually need to be formated...
  10. R

    Histogram Like Line in charts [SOLVED]

    OK so far I have a scatter plot with lines connecting, but I can't get the lines that connect the dots to do that effect so far. Any ideas on how to do it?
  11. R

    Histogram Like Line in charts [SOLVED]

    If I do that the connectors will not make the effect I want as in the uploaded picture...
  12. R

    Histogram Like Line in charts [SOLVED]

    Hi, I am trying to understand if it is possible to get in excel 2010 a graph that looks like the one in the picture attached. I mean the red line which changes and acts like a histogram, altough it is not a histogram. With each new value the line "jumps" up/down to the next one which it...
  13. R

    Grab variable data from different Tab to Plot

    Ok thanks! I will try to remake it on the other one. the macro itself I have no idea how to make it but I will search first. thanks!
  14. R

    Grab variable data from different Tab to Plot

    UAU This is A-M-A-Z-I-N-G!!! It's exatly what I wanted!!! I will now try to do the same into the original file which is much bigger and holds confidential data. That's only reason I coundn't send it over. I see on the first tab there is a cell with a code regarding some index wich I guess...
  15. R

    Grab variable data from different Tab to Plot

    Hi and thanks for the help! I apologise I didn't reply earlier. This has absolutelly no urgency whatsoever, I just needed it eventually. I hope I didn't make you lose any sleep, I'm so sorry. The macro option would be the best solution and was actually what I was looking for since the...
  16. R

    Grab variable data from different Tab to Plot

    I actually know very little about excel, but I assume that by "Straight Connector" you mean the blue separator lines that I have drawn. They are irrelevant, I will place them by hand. They are simply visual markers and not important. Thanks for the help! Really appreciate it!
  17. R

    Grab variable data from different Tab to Plot

    Thanks for that info. Here is a small version of the file. The original data and calculation is in the “01.GasData” tab, from where I copy. The plot on “02.Plot” is getting the data from that small table next to it where I have pasted the data from “01.GasData”. I want to be able to add the...
  18. R

    Grab variable data from different Tab to Plot

    Hello, This is my first time posting here and I have a question about charts and data selection. My goal is to create a Gas Ratio Pixler Plot which involves 5 columns of data, the first one will refer to a depth and the other 4 ones will plot points which together will form a line. That is...
Back
Top