Need help with Line Chart...

F

Fergal

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.
 
B

Bernard Liengme

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
 
J

Jarek Kujawa

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
 
S

Shane Devenshire

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.
 
G

Glenn

Fergal said:
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.
 
F

Fergal

Fergal said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top