Why should i prepare
my data?
Makes charting easyer,
amalysis easyer.
How do I prepare my data for making charts?
To Traditionally dependent
variables are placed on the left most column
in excel with the independent variable in
the next column to the left. Excel automatically
assumes that the dependent variable is in
the first column of data and so assigns it
to the y axis and the next colum of data
to the x axis. For every column after that
Excel creates a new series as by default
it assumes that each new column is a seperate
independent varaible and therefor creates
a new series of data points on the chart
for it.
Related
Knowledgebase Pages The Bar chart
The Line chart
The Pie chart
The Scatter chart
Method I and Method II
Method I vs method II scatter chart
Method I vs method II line chart
Related
QuickSkills How to make a column
chart
How to make a bar chart
How to make a scatter chart
How to make a line chart
How to make a pie chart
