Prev: How do I set up a GANTT chart for a research proposal
Next: Excel 2007 - How can I switch the data on vertical and horizontal
From: kylefoley2000 on 25 Mar 2010 08:15
i have two sets of data

on the left column represents time, hours. i want the numbers on the right
to be appear on the graph at the appropriate hour. so 9.0 should appear at
the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the chart,
the hours being spread by ones on the x axis.

43 9.0
52 4.8
81 5.9
242 1.5
146 3.8
159 2.9
194 3.3
217 2.6
242 3.5
251 2.9
312 3.0
355 2.0
454 1.9


From: Luke M on 25 Mar 2010 08:53
Create an XY scatter chart, with the first column being your X-axis.

--
Best Regards,

Luke M
"kylefoley2000" <kylefoley2000(a)discussions.microsoft.com> wrote in message
news:1CA49BEC-6648-4AF6-B694-488C5A1E4F5D(a)microsoft.com...
>i have two sets of data
>
> on the left column represents time, hours. i want the numbers on the
> right
> to be appear on the graph at the appropriate hour. so 9.0 should appear
> at
> the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the
> chart,
> the hours being spread by ones on the x axis.
>
> 43 9.0
> 52 4.8
> 81 5.9
> 242 1.5
> 146 3.8
> 159 2.9
> 194 3.3
> 217 2.6
> 242 3.5
> 251 2.9
> 312 3.0
> 355 2.0
> 454 1.9
>
>


From: trip_to_tokyo on 25 Mar 2010 09:06
Hi Kyle.

I have just put up an EXCEL 2007 file for you at:-

http://www.pierrefondes.com/

- item number 79 towards the top of my home page.

I think that this gives you what you want.

If you agree please hit Yes.

Thanks.



"kylefoley2000" wrote:

> i have two sets of data
>
> on the left column represents time, hours. i want the numbers on the right
> to be appear on the graph at the appropriate hour. so 9.0 should appear at
> the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the chart,
> the hours being spread by ones on the x axis.
>
> 43 9.0
> 52 4.8
> 81 5.9
> 242 1.5
> 146 3.8
> 159 2.9
> 194 3.3
> 217 2.6
> 242 3.5
> 251 2.9
> 312 3.0
> 355 2.0
> 454 1.9
>
>
 | 
Pages: 1
Prev: How do I set up a GANTT chart for a research proposal
Next: Excel 2007 - How can I switch the data on vertical and horizontal