Excel (1 Viewer)

[Korn]

I know this is a fairly simple thing to do but, how do you create charts, I know where the button is but how do you set up the spreadsheet properly so that it does the graphing and labelling that you want it to do.

ATM I dont have a specific graph I want to make, but will probably need it quite soon

 

[MedNez]

Select your data, hit the graph button - follow the wizard

 

[Korn]

Select your data, hit the graph button - follow the wizard

Yeah I got that knowledge but how do you set out the source data, I'll give an example if it will help

 

[MedNez]

I did this quickly - if you set it out as below - that graphs points vs. month (with the names as labels for the data series). That format is a good way to do it.

Or columns with your data.