[mso] Re: FW: line graphs in excel

Another way of persuading the lines to be drawn would be to interpolate data
for the missing year(s). In other words, calculate what the data would be
assuming a directly proportional relationship. If you did not want that data
to show in your table, you could set the font colour of the interpolated
data to white.

HTH

Andrew 

> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx 
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Ann E Fitzmaurice
> Sent: 24 January 2007 09:46
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] FW: line graphs in excel
> 
> Hi all
>  
> 
> I think I understand the problem below, 
> 
> I have data for the years 1990-2000, in the countries where 
> there is data for all years the points on a line grapgh are joined
> 
> In the countries where the information is missing for some of 
> the points , where there are two consecutive data points the 
> line is drawn, and where the next data point is after a break 
> in the sequence the two points are not connected by a line, 
> although I realise that a straight line between two points in 
> time which are not equally spaced  assumes a linear 
> relationship between the points, nevertheless I require the 
> points for all series on the graph to be joined by lines
> 
>  
> 
> The only way I can find of doing ot is to draw in the lines manually
> 
>  
> 
> Any suggestions
> 
> Ann

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: