Word And Excel (object Linking And Embedding...)

[techquilla]

" Project 6 due Dec. 3

--Use Microsoft Excel to import a student grade file and compute average

for each student, home work, or examination.

--Sort students by decreasing order of total score.

--Type one page of Word document and import the grade histogram chart.

--Demonstrate the difference of object linking and embedding with

histogram chart.

?@

Download the excel file"

this is my homework that i got to do........the thing i don't understand is the difference between object linking and embedding and how do i show the difference.....?

thanks....

[Malechai Veteran]

object linking is when it leaves an icon in the document. when you click the icon, the respective program loads.

object embedding is when that specific program itself is embedded (or inserted) within the document itself. see the attached pic. thats Excel embedded inside the word document.

[techquilla]

thanks alot..... Spyder....!!

now i got another problem.....

the project asks me to create a historgram chart from the table in the excel file........i can get the right format of the chart so that the ID numbers, which are not continuous, be on the y-axis, and the grades for each category(seprated by series) be on the x -axis.....can i help me on that...? thanks alot.....BTW....this the link for the excel file.....^^

http://www.cmlab.csie.ntu.edu.tw/~locking/Book1.xls

[Malechai Veteran]

i'd like to help you out further, but i'm at work right now... and i won't be home for another 6 hours or so. Hopefully someone else can help you out. sorry man!

[techquilla]

i'd like to help you out further, but i'm at work right now... and i won't be home for another 6 hours or so. Hopefully someone else can help you out. sorry man!

that's ok, i can wait till tomorrow.....but thanks anyways.....^^

[techquilla]

anybody else can help me?

[hurting101]

i can get the right format of the chart so that the ID numbers, which are not continuous, be on the y-axis, and the grades for each category(seprated by series) be on the x -axis

I'm not quite sure what you mean by that... can you clarify?

Is this what you want? (see attachment). If so, get it by doing this:

select data cells > click Chart Wizard > (select type) > Next > Series in: Columns, instead of Rows.

[techquilla]

nope, that is not it,......

the first column of table is the ID of each student, starting from the second column are the grades for test and homeworks....so basically, it is like a gradebook.....what i gotta do is ilustrate it with a graph using excel...

the ID tag should be treated like names of student not numbers like the one on your graph, the graph should illsutrate the grade (1-100) of each student for every work done........

thanks anyways for trying...i appreciated it......^^ i know this is very complicated cuz i just cannot get so many things on a single graph......

[hurting101]

I'm not sure exactly how to do it, but you can force the student IDs to be treated names by putting a # infront of them (not sure if you're allowed to do this or not). I couldn't get the IDs on the far left (y axis), though. See attachment.

For example, the ID column would look like this:

#880514

#880516

#880535

#880719

#880732

...

[Keldyn]

thread moved to software assistance

[cheekymonkey]

Hope this helps.

Ya need to resize text so that all IDs are shown, but I think this may be what you want.

If not please reply cos I'm sure I can help.

Don't us staff rule?

Book1.zip

[techquilla]

thanks to cheekymonkey and hurting101......

ckeekymonkey, yes, the one you did is almost like how i wanted it except that the grades for each work should be on a seperate bar......can you do that......

anyways....thanks alot....!!

BTW, how do you do this object linking and embedding thinggy......^^

[techquilla]

one more thing....can you tell me how do did it? so i can try it myself...? thanks...

[techquilla]

anyone....?

[Steven]

Moved To Programming...

-xStainDx

[Gumboot]

Err, this has nothing to do with Programming; why move it here? :wacko:

[techquilla]

hahah that's exactly what i wanted to say...why move it to programming...???????? :blink:

it was fine is software discussion......somebody should move it back....^^