Can I make Excel sort and graph a list of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know if my Excel can take a list of numbers and sort then graph
them.

Thanks again,
Nivek
 
To sort the data, select the data set then use Data | Sort... and
provide the necessary information.

To chart a data set, select it, click the Chart Wizard button and follow
instructions.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
What I should have asked was, Can Excel count how many 0's, 1's, 2's, 3's,
and 4's are in a column then graph the resulting numbers?

Thanks to whoever tells me how to do this,
Nivek
 
Check out XL's FREQUENCY function, its Histogram capability (Tools |
Data Analysis... | Histogram tool), or its PivotTable capability (Data |
Pivottable and PivotChart Reports...)

The latter 2 have a chart option in them. For the first, create a chart
based on the results of the FREQUENCY function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Back
Top