The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    X-Y-Z Scatterplots in Excel, or similar program

    Discussion in 'Windows OS and Software' started by Tyranids, Aug 10, 2012.

  1. Tyranids

    Tyranids Notebook Evangelist

    Reputations:
    332
    Messages:
    525
    Likes Received:
    0
    Trophy Points:
    30
    Hello all, I went through a series of tests with MSI Afterburner trying to determine a ratio, or some kind of pattern to core clock and memory clock for optimal performance on the Nvidia GTX 680M at its stock voltage. I gathered all of my data, but can't find a way in excel to have the core and memory speeds as X and Y axes, then the P Score from 3DMark11 as a third item on the Z axis. Here's my data if anyone's interested:
     

    Attached Files:

  2. tijo

    tijo Sacred Blame

    Reputations:
    7,588
    Messages:
    10,023
    Likes Received:
    1,077
    Trophy Points:
    581
    Well, you could do a dual Y axis plot if worse comes to pass, it will still allow you to show the data on the same plot. From what i can tell Excel 2010 and prior can't do 3D scatterplots I could check in office 15 though, but first, dinner...

    EDIT:

    Been a while since i used MATLAB, here's what i pulled off on short notice:

    GTX680m_OC.png

    Here's the code i used by the way:

    Code:
    core_clock = [719 719 719 719 719 719 719 719 749 749 749 784 784 784 819 819 819 854 854 854];
    memory_clock = [900 950 1000 1050 1100 1150 1200 1250 900 950 1000 900 950 1000 900 950 1000 900 950 1000];
    p_score = [6100 6135 6157 6180 6197 6223 6251 6239 6267 6327 6347 6491 6529 6588 6720 6772 6803 6919 6976 7008];
    
    scatter3(core_clock, memory_clock, p_score, 100, 'black', 'filled')
    title('GTX680m Overclocking Results')
    xlabel('Core Clock')
    ylabel('Memory Clock')
    zlabel('P Score 3D Mark 11')
    axis([700 900 850 1100 6000 7100])
    
     
  3. Tyranids

    Tyranids Notebook Evangelist

    Reputations:
    332
    Messages:
    525
    Likes Received:
    0
    Trophy Points:
    30
    Thank you very much. I don't have MATLAB, nor do I know how to use it, although I will be learning in a couple of weeks. That was pretty much exactly what I was looking for though, thank you very much.