automaticly create graph

[dunc]

what i would like to do is create a spread sheet where by i entered the fixed
and variable costs as well as the selling price. i would then like a graph to
automaicly change and display the this info.
Does anyone know how to do this.

 

[David Biddulph]

Decide which cells on the spreadsheet you wish to include in the chart.
Select those cells. Follow the menu option: Insert/ Chart, and answer the
questions in the wizard.

Have you looked in Excel help at the topics concerned with charts, starting
with "Create a chart"?

Have you looked at the training material under
http://office.microsoft.com/en-gb/training/CR061831141033.aspx
including
http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033
http://office.microsoft.com/training/training.aspx?AssetID=RC011097791033
http://office.microsoft.com/training/training.aspx?AssetID=RC011185911033 ?

Do you have a specific question?

 

[dunc]

thank you very much i feel a bit silly now as i did not realise the graph
changes as i change the values. i thought once it was created it was fixed.