Excel 2008 gurus? Need help asap!

[AhmedRSi]

Working on a lab report, come upon a little hiccup in excel. Whenev I try to add a regular line (not trendline) to this set of results, it goes crazy!

Any ideas? Its probably an easy fix

 

[Mike_182]

Never seen Excel 2008. :s

 

[AhmedRSi]

I meant 2007! LOL, can a mod edit title pleasse?

 

[AhmedRSi]

This is what happens when i attempt to add a line colour. see what happens? [most obvious in the green line]

 

[M8XY G]

never seen 2007 but im good with excel, have you tried changing the type of line graph?

 

[AhmedRSi]

I see myself as brilliant in excel but cant understand why this has happened... its like excel thinks the lower value data occured at a time before ... it doesnt make sense and is hard to explain!

 

[The Boosh!]

i think you need to re arrange your table of your source data... your confusing excel... its not joining up because you have gaps in your data.
IE at 50 mins there is 2 blanks and then some data...

at a guess id say this is confusing it.

try arranging your data horizontally?

 

[AhmedRSi]

Hmm... fixed it by removing the blank cells and using 2 seperate time scales. Annoying bug

 

[AhmedRSi]

i think you need to re arrange your table of your source data... your confusing excel... its not joining up because you have gaps in your data.
IE at 50 mins there is 2 blanks and then some data...

at a guess id say this is confusing it.

try arranging your data horizontally?

Thanks

Confused computer FTL

 

[AhmedRSi]

Done... ish

 

[The Boosh!]

yeh its a bit s**t tbh...

it doesn't like it if you try making graphs from different sheets either (ie loads of data of different sheets)

lol getting there then!

 

[iain187]

if you want to put your data set back to how it was, try putting =NA() in the blank cells


or to do it properly:

click on your chart > you should have 3 new options at the top in the section 'chart tools' > you want 'design' > in the 'data' section you have select data > bottom left of the window that pops up is 'hidden and empty cells' > 'Connect data points with line'

I thank ya

 

[AhmedRSi]

Edit - thanks guys

 

[gr1340]

You can fix this fairly easily.
Go back to your original graph where there are gaps and I will use the green line as the example.
Opposite click on one of the green points and go to Select Data.
In this window, click Hidden and empty Cells button.
Select Connect data points with line then click OK.
Click ok again and watch the gaps fill!!!!

 

[gr1340]

Beaten to it by seconds

 

[iain187]

:rasp:

 

[gr1340]

 

[Daz]

Never seen Excel 2008. :s

That's the Mac Version

 

[AhmedRSi]

Another question... how do i now get excel to produce and average of these 3 lines? I cant average the data as it was taken at different time intervals... if you know what I mean

 

[iain187]

try =NA(), if not work out the missing values I guess.