Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Could somebody help me to build this one?

Here's image.

This diagram tells about number of CPU cores during each year (X-axis) in TOP-500 comuters (Y-axis), digits right are number of cores. It seems to me that it would be an AREA CHART. But something wrong happens when I change Y-axis range from default to 0-500. Need your help so much. Thanx.

share|improve this question
    
You're trying to do this in word?! Surely Excel would be a better choice. –  Majenko Apr 2 '11 at 13:57
    
Thanx, of course. When I start to build it in Word, new Excel window opens immediatly, and there I change datas. So I have my problem in changing datas in Excel. –  Daria Apr 2 '11 at 13:59
    
So tell us - what is this "wrong thing" that happens? Can you show us what happens? –  Majenko Apr 2 '11 at 14:02
    
Thanx, of course: link - if I don't change Y-axis, but it isn't what I need. link - if I change Y-axis to what I need. Thanx. –  Daria Apr 2 '11 at 14:15
add comment

1 Answer

up vote 0 down vote accepted

From my experiments what you want is a stacked area graph. You also need each column to contain the value for just that one count or processor cores:

enter image description here

Column F contains =sum(B2:E2) for each row (B3:E3 etc) to make sure that each row adds up to 500. This is just for reference, and I'm not sure if the data is exactly what you have (I guessed at some numbers) but with each row totaling 500 the total height of each maximum point in the graph should be 500. It auto-sizes to 600 on mine, so I have to manually tweak it to 500 to get rid of the unsightly gap at the top, but it works nonetheless.

share|improve this answer
    
Thank you very very much! Hope it would helpfull fo me. –  Daria Apr 4 '11 at 9:55
    
I just cannot change Y-axis - it's always 0-1! If I change it manually on Axis format to 0-500 I have the this result, and nothing draws. Can you advise me what to do? Thanx. –  Daria Apr 4 '11 at 10:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.