Esato Mobile
General discussions : Non mobile discussion : Excel
> New Topic
> Reply
< Esato Forum Index > General discussions > Non mobile discussion > Excel Bookmark topic
haynesycop Posts: > 500

I have a graph to complete for university, basically i have to create it with three sets of data (see picture attached)

I have never had to use three tables before and i am not sure how exactly to set it out before choosing the graph?

I have had a play around putting the data in various ways but each time the graph doesn't look right.

This is what i mean by three different tables.



Thanks
--
Posted: 2006-12-06 18:56:43
Edit : Quote

Luke-the-magic-man Posts: > 500

line graps, or bar charts may do it for each set of data?
--
Posted: 2006-12-06 19:25:18
Edit : Quote

haynesycop Posts: > 500

Ok so i have found an example and put my data into it and here is what it looks like in excel:



Now when i highlight it all and create an xy scatter graph it looks really weird lol, do i have to create three separate graphs and somehow merge them into one?
--
Posted: 2006-12-06 19:26:39
Edit : Quote

Luke-the-magic-man Posts: > 500

um you will probally have to put them into 3 different graphs
--
Posted: 2006-12-06 19:32:50
Edit : Quote

haynesycop Posts: > 500

I thought that but the sheet says plot a suitable graph not three because i have to use the data from the first two graphs to calculate stuff for the third lol.

I HATE EXCEL!!!


--
Posted: 2006-12-06 19:36:35
Edit : Quote

New Topic   Reply
Forum Index

Esato home