Need help with Line Chart...
 

Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column two
"WEIGHT" contains daily weights in Stones & Pounds or even just Pounds. This
would then be displayed on a line chart with Weights top to bottm on left
hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.

Need help with Line Chart...
 

Select the range of data to be plotted (both columns)
Open the Inset tab on the Ribbon
In the Chart group, select Line and from the offered subtype click on the
first one
Tell us if you are successful.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fergal" wrote in message
. ..
Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column
two "WEIGHT" contains daily weights in Stones & Pounds or even just
Pounds. This would then be displayed on a line chart with Weights top to
bottm on left hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.

Need help with Line Chart...
 

select yr data
press F11
Excel should add a chart sheet
if it is not a Line Chart but e.g. Column Chart then click on one of
the columns, click Chart Type, and select Line CHart

HTH

On 23 Mar, 15:16, "Fergal" wrote:
Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column two
"WEIGHT" contains daily weights in Stones & Pounds or even just Pounds. This
would then be displayed on a line chart with Weights top to bottm on left
hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.

Need help with Line Chart...
 

Hi,

Suppose your Dates are in A1:A13 and the weights in B1:B13 with title on row
1. Select the data and press Alt+F1. This will create a pie chart for
example. Then choose Chart Tools, Design, Change Chart Type and pick any
Line chart type you want.

If you want the chart on its own page, follow the steps above but press F11.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fergal" wrote:

Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column two
"WEIGHT" contains daily weights in Stones & Pounds or even just Pounds. This
would then be displayed on a line chart with Weights top to bottm on left
hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.

Need help with Line Chart...
 

Fergal wrote:
Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column two
"WEIGHT" contains daily weights in Stones & Pounds or even just Pounds. This
would then be displayed on a line chart with Weights top to bottm on left
hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.



Select your data, including headers. From the Insert menu select Chart. Select
Line under Standard Types and click Finish.

Need help with Line Chart...
 

"Fergal" wrote in message
. ..
Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE" contains a series of dates, column
two "WEIGHT" contains daily weights in Stones & Pounds or even just
Pounds. This would then be displayed on a line chart with Weights top to
bottm on left hand side& Dates along the bottom left to right
I hope this makes sense to somebody, many thanks for any replies given.

Many Thanks for all replies.