ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   GRAPH (https://www.excelbanter.com/excel-discussion-misc-queries/206612-graph.html)

[email protected]

GRAPH
 
I have lots of data (around 10000). I want to draw graph to analyze
these data. I want to see the distribution.

Example data:
0.0158880
0.0168880
1.0158880
0.2158880



What type of graph should I draw and how ?

Bernie Deitrick

GRAPH
 
friend,

You could use the FREQUENCY function to count and then plot the data. Take a look in Help.

HTH,
Bernie
MS Excel MVP


" wrote in message
...
I have lots of data (around 10000). I want to draw graph to analyze
these data. I want to see the distribution.

Example data:
0.0158880
0.0168880
1.0158880
0.2158880



What type of graph should I draw and how ?




Mike Middleton

GRAPH
 
friend.05 -

"Manual" method uses array-entered FREQUENCY worksheet function and a Column
chart type.

Automated method uses the Histogram tool of the Analysis ToolPak add-in
(provided on the Install disk).

Or, try the free Better Histogram add-in, available from the Histogram page
at http://www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



" wrote in message
...
I have lots of data (around 10000). I want to draw graph to analyze
these data. I want to see the distribution.

Example data:
0.0158880
0.0168880
1.0158880
0.2158880



What type of graph should I draw and how ?





All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com