1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Windows Excel Graphing Help

Discussion in 'Software' started by Guest-16, 23 Jan 2009.

  1. Guest-16

    Guest-16 Guest

    Hi all,

    How do I do the graph below in Office 07?

    [​IMG]

    I can't for the life of me work out if it's even possible to do in 07, but I know I used to be able to.

    The GPU DeltaT needs to be the X-axis label
    The CPU DeltaT needs to be the Y-axis label
    Idle needs to be the Title
    The case names need to be the individual dots.

    We are trying to correlate CPU and GPU temperatures to cases to see which is better.
     
  2. yodasarmpit

    yodasarmpit Modder

    Joined:
    27 May 2002
    Posts:
    11,358
    Likes Received:
    205
    Is it just the labels for the data set and axis you cant do, as you appear to have plotted the graph fine.

    Like so?
    [​IMG]
     
    Last edited: 23 Jan 2009
  3. Guest-16

    Guest-16 Guest

    Yea, I cant work out where the options are to do ^^ this :( The plot is fine, I just cant tweak it. Right click has no options that are relevant.
     
  4. DougEdey

    DougEdey I pwn all your storage

    Joined:
    5 Jul 2005
    Posts:
    13,933
    Likes Received:
    33
    With the labels, you just need to change the format of the graph:

    Select the graph -> Design -> Chart Layouts, then you can edit them

    For the series I found the best way was to add the data in (it plots with two points for each) then click and drag the Purple & Blue boxes (X/Y) on the spreadsheet
     
  5. felix the cat

    felix the cat Spaceman Spiff

    Joined:
    11 Jan 2002
    Posts:
    4,914
    Likes Received:
    11
    never used the new office (cos im old skool :rock:) but do you not have a source data button:
    [​IMG]

    ...with this is takes you straight to were you declare your series (with x/y axis data and legend)...surely ms has not made drawing graphs more difficult??
     
  6. DougEdey

    DougEdey I pwn all your storage

    Joined:
    5 Jul 2005
    Posts:
    13,933
    Likes Received:
    33
    It's the same, but you can now just drag and drop the boxes, easier IMHOP
     
  7. Glider

    Glider /dev/null

    Joined:
    2 Aug 2005
    Posts:
    4,173
    Likes Received:
    21
    Oh yes they did...

    I think you should take a look at the "Select Data" button under the first extra menu that appears when you select the graph (sorry, Dutch version over here).
     
  8. yodasarmpit

    yodasarmpit Modder

    Joined:
    27 May 2002
    Posts:
    11,358
    Likes Received:
    205
    MS screwed up Excel Royally.
    I can't find a thing in 2007, and I hate the ribbon bar at the top.

    They have made one major improvement though, the removal of the 65,000 row limit.

    We still use 2003 at work, so that's what I'm more used to, I guess given time I'd get used to 2007.
     
  9. Guest-16

    Guest-16 Guest

    Don't get me wrong - I love the ribbon and can't live without 07 now. Anything else is backwards.

    HOWEVER, they've hidden features in 07 that used to be in 03 :(

    Felix - that's what I'm looking for, and it's just not there :(

    [​IMG]
     
  10. Guest-16

    Guest-16 Guest

    Right, I've got that far. The format tab at the top, then several other clicks to get this below. Now to just assign the case names instead of the values (why TF would you want values and not telling them what they are? - yes, it's 12 and I can see it's 12 BECAUSE THAT's WHAT THE X-AXIS IS FOR!!)

    [​IMG]
     
  11. §§...

    §§... What's a Dremel?

    Joined:
    19 Mar 2003
    Posts:
    72
    Likes Received:
    5
    Not sure if you've fixed this, but i'll give it a go anyway...

    [​IMG]
    first right click graph area, and click 'select data'

    [​IMG]
    click the 'add' button and...

    [​IMG]
    add the series of name (or case), x and y data

    [​IMG]
    click OK, then add, repeat the same for however many cases

    [​IMG]
    once you're done, go to 'layout' tab, and there should be all the formating options for any x, y or chart labels you wish to add/edit.

    and that should be it really... it seems like a roundabout way (20 times for 20 cases....?) but that's how i got it to work...you may find a quicker way. Hope that helped!
    btw, image tags dont seem to be working, so added them as links.

    edit: fixed image links
     
    Last edited: 15 Feb 2009

Share This Page