Graph...Plz Help...

[prakash_nemade7]

I want to create graph of following values.takin following valus on(range) x-axis.as my all values lies between 0 to 1.
here Im givin 1000 values
the value suppose 0.485 comes 60 times so it should hit 60 on y-axis.
the values are
0.651
0.476
0.519
0.361
0.413
0.417
0.457
0.617
0.421
0.477
0.627
0.517
0.489
0.493
0.172
0.475
0.509
0.526
0.687
0.468
0.497
0.529
0.421
0.423
0.485
0.433
0.721
0.483
0.689
0.189
0.482
0.521
0.604
0.380
0.384
0.083
0.450
0.457
0.659
0.446
0.312
0.559
0.595
0.442
0.478
0.442
0.393
0.582
0.440
0.606
0.419
0.387
0.493
0.458
0.394
0.658
0.413
0.492
0.484
0.238
0.538
0.363
0.451
0.758
0.522
0.637
0.415
0.314
0.375
0.416
0.512
0.571
0.593
0.685
0.590
0.584
0.541
0.714
0.465
0.388
0.563
0.548
0.550
0.467
0.427
0.457
0.437
0.409
0.488
0.414
0.405
0.583
0.404
0.470
0.630
0.658
0.595
0.523
0.224
0.414
0.446
0.504
0.448
0.532
0.542
0.431
0.624
0.567
0.416
0.568
0.677
0.457
0.395
0.448
0.439
0.406
0.663
0.574
0.503
0.451
0.669
0.618
0.750
0.503
0.664
0.461
0.549
0.431
0.701
0.593
0.627
0.578
0.401
0.551
0.377
0.647
0.451
0.683
0.443
0.379
0.354
0.553
0.200
0.390
0.512
0.417
0.488
0.431
0.584
0.425
0.429
0.436
0.190
0.447
0.450
0.348
0.477
0.447
0.546
0.413
0.467
0.595
0.396
0.165
0.661
0.429
0.573
0.595
0.530
0.277
0.398
0.412
0.416
0.462
0.443
0.541
0.500
0.426
0.392
0.439
0.530
0.606
0.111
0.443
0.589
0.423
0.526
0.511
0.519
0.616
0.400
0.328
0.483
0.454
0.415
0.424
0.434
0.625
0.429
0.484
0.427
0.473
0.442
0.566
0.489
0.172
0.526
0.557
0.402
0.561
0.565
0.407
0.603
0.591
0.454
0.458
0.544
0.390
0.557
0.490
0.571
0.761
0.446
0.413
0.410
0.467
0.405
0.481
0.456
0.516
0.593
0.386
0.473
0.661
0.675
0.429
0.604
0.388
0.484
0.415
0.436
0.534
0.454
0.426
0.398
0.238
0.685
0.602
0.503
0.468
0.607
0.377
0.494
0.423
0.221
0.554
0.616
0.414
0.421
0.722
0.533
0.672
0.409
0.656
0.186
0.461
0.460
0.361
0.405
0.241
0.487
0.714
0.452
0.497
0.478
0.449
0.486
0.387
0.630
0.527
0.416
0.433
0.546
0.474
0.489
0.511
0.408
0.489
0.645
0.485
0.466
0.490
0.612
0.140
0.458
0.336
0.409
0.542
0.367
0.769
0.464
0.604
0.466
0.512
0.473
0.388
0.727
0.537
0.465
0.474
0.328
0.433
0.502
0.434
0.503
0.501
0.551
0.294
0.376
0.426
0.577
0.488
0.369
0.495
0.599
0.398
0.564
0.501
0.648
0.514
0.532
0.510
0.550
0.674
0.397
0.397
0.421
0.465
0.470
0.572
0.471
0.660
0.779
0.442
0.209
0.432
0.403
0.471
0.525
0.684
0.494
0.556
0.648
0.341
0.606
0.442
0.296
0.467
0.412
0.612
0.665
0.619
0.715
0.424
0.685
0.438
0.464
0.582
0.489
0.570
0.338
0.409
0.495
0.494
0.514
0.506
0.392
0.423
0.549
0.485
0.471
0.529
0.621
0.512
0.483
0.495
0.347
0.537
0.468
0.507
0.547
0.411
0.372
0.482
0.503
0.405
0.389
0.152
0.602
0.396
0.422
0.418
0.481
0.399
0.439
0.516
0.418
0.408
0.451
0.188
0.458
0.243
0.486
0.416
0.536
0.483
0.083
0.497
0.611
0.474
0.429
0.477
0.398
0.432
0.696
0.348
0.314
0.418
0.585
0.435
0.632
0.083
0.522
0.464
0.519
0.430
0.463
0.665
0.390
0.435
0.643
0.559
0.459
0.382
0.415
0.446
0.532
0.456
0.402
0.726
0.472
0.672
0.406
0.360
0.444
0.503
0.465
0.482
0.473
0.453
0.516
0.439
0.450
0.349
0.474
0.334
0.357
0.372
0.189
0.523
0.461
0.528
0.485
0.577
0.634
0.296
0.464
0.493
0.519
0.455
0.534
0.369
0.471
0.568
0.523
0.460
0.569
0.462
0.485
0.364
0.545
0.623
0.483
0.420
0.608
0.518
0.410
0.576
0.436
0.480
0.361
0.472
0.424
0.526
0.522
0.476
0.457
0.478
0.441
0.532
0.448
0.459
0.546
0.601
0.152
0.396
0.639
0.420
0.496
0.609
0.429
0.628
0.382
0.385
0.512
0.438
0.461
0.388
0.520
0.663
0.450
0.491
0.375
0.441
0.422
0.380
0.734
0.330
0.419
0.646
0.659
0.403
0.475
0.379
0.459
0.443
0.096
0.352
0.606
0.426
0.390
0.434
0.609
0.429
0.431
0.522
0.468
0.405
0.750
0.442
0.454
0.454
0.381
0.586
0.380
0.528
0.382
0.502
0.441
0.451
0.186
0.442
0.500
0.496
0.862
0.612
0.522
0.422
0.453
0.435
0.519
0.304
0.467
0.438
0.291
0.561
0.544
0.576
0.404
0.420
0.540
0.396
0.447
0.504
0.428
0.370
0.512
0.323
0.431
0.600
0.416
0.582
0.351
0.384
0.489
0.272
0.440
0.415
0.416
0.490
0.489
0.506
0.655
0.561
0.420
0.388
0.473
0.235
0.659
0.540
0.533
0.571
0.550
0.437
0.354
0.640
0.427
0.681
0.463
0.438
0.582
0.599
0.531
0.656
0.193
0.468
0.500
0.570
0.413
0.475
0.450
0.411
0.444
0.581
0.493
0.455
0.444
0.421
0.625
0.475
0.447
0.413
0.465
0.467
0.612
0.446
0.409
0.480
0.425
0.494
0.290
0.125
0.582
0.453
0.548
0.419
0.610
0.517
0.476
0.572
0.614
0.466
0.460
0.542
0.332
0.532
0.384
0.481
0.433
0.585
0.235
0.681
0.627
0.527
0.479
0.555
0.490
0.720
0.579
0.401
0.441
0.411
0.483
0.433
0.466
0.557
0.526
0.473
0.413
0.470
0.454
0.626
0.339
0.186
0.503
0.535
0.446
0.631
0.541
0.320
0.421
0.402
0.409
0.398
0.455
0.488
0.529
0.411
0.490
0.368
0.402
0.416
0.537
0.457
0.594
0.646
0.531
0.422
0.534
0.412
0.404
0.473
0.722
0.422
0.566
0.503
0.362
0.480
0.487
0.474
0.490
0.380
0.390
0.667
0.495
0.491
0.618
0.303
0.537
0.629
0.597
0.364
0.692
0.470
0.687
0.493
0.424
0.398
0.514
0.349
0.456
0.454
0.397
0.377
0.529
0.449
0.521
0.443
0.491
0.621
0.401
0.474
0.484
0.582
0.413
0.243
0.564
0.504
0.495
0.460
0.636
0.572
0.466
0.543
0.436
0.469
0.720
0.462
0.504
0.471
0.442
0.569
0.573
0.472
0.431
0.354
0.409
0.666
0.697
0.530
0.382
0.438
0.411
0.475
0.538
0.493
0.408
0.438
0.402
0.360
0.600
0.434
0.626
0.437
0.428
0.547
0.519
0.436
0.428
0.642
0.519
0.486
0.483
0.483
0.569
0.662
0.428
0.431
0.398
0.479
0.442
0.591
0.454
0.444
0.390
0.657
0.236
0.453
0.481
0.615
0.428
0.423
0.506
0.632
0.486
0.613
0.454
0.428
0.534
0.387
0.495
0.381
0.487
0.561
0.428
0.374
0.658
0.469
0.489
0.370
0.404
0.425
0.488
0.436
0.478
0.417
0.450
0.391
0.452
0.473
0.702
0.593
0.400
0.503
0.373
0.369
0.545
0.466
0.500
0.401
0.598
0.439
0.420
0.548
0.606
0.390
0.435
0.467
0.673
0.401
0.245
0.407
0.645
0.523
0.414
0.496
0.365
0.507
0.382
0.455
0.443
0.460
0.525
0.481
0.482
0.429
0.514
0.488
0.568
0.509
0.411
0.465
0.412
0.423
0.657
0.537
0.470
0.495
0.454
0.350
0.411
0.426
0.477
0.643
0.544
0.535
0.416
0.413
0.380
0.500
0.438
0.438
0.384
0.563
0.550
0.465
0.454
0.492
0.567
0.565
0.400
0.513
0.350
0.435
0.396
0.493
0.459
0.468
0.514
0.432
0.730
0.372
0.593
0.655
0.395
0.658
0.784
0.465
0.364
0.614
0.533
0.531
0.464
0.430
0.654
0.526
0.404
0.535
0.411
0.609
0.662
0.455
0.437
0.469
0.450
0.415
0.492
0.598
0.551
0.493
0.402
0.474
0.345
0.586
0.437
0.469
0.519
0.659
0.523
0.444
0.590
0.543
0.386
0.361
0.476
0.544
0.439
0.451
0.592

 

[pcc]

Put all values in column A with a header in A1, (called eg "Value")
Do a pivot table with value as the row field,, and count of value as the data. Press F11 to get the chart.

 

[wigi]

Another way might be to:

- put values in column A
- put COUNTIF formulas in column B to count occurrences of corresponding value in A
- plot them in chart


Yet another way might be to:

- put values in column A
- put them also in column B
- make sure Analysis Toolpak is installed
- make a histogram with the input values in A and bin ranges in B

Wigi