Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
I want to know if my Excel can take a list of numbers and sort then graph
them. Thanks again, Nivek |
#2
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
In article ,
says... I want to know if my Excel can take a list of numbers and sort then graph them. Thanks again, Nivek Yes, it can do both. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#3
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
Could you tell me how?
Thanks, Nivek "Tushar Mehta" wrote: In article , says... I want to know if my Excel can take a list of numbers and sort then graph them. Thanks again, Nivek Yes, it can do both. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#4
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
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 In article , says... Could you tell me how? Thanks, Nivek "Tushar Mehta" wrote: In article , says... I want to know if my Excel can take a list of numbers and sort then graph them. Thanks again, Nivek Yes, it can do both. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#5
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
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 |
#6
|
|||
|
|||
Can I make Excel sort and graph a list of numbers?
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 In article , says... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Novice trying to sort the values on a radar graph | Charts and Charting in Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel | |||
Sort order for graph only and not spreadsheet | Excel Discussion (Misc queries) | |||
Sort data for graph only | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel |