Draw Histogram in Excel: Is it Possible?

  • Thread starter Thread starter manjuvenamma
  • Start date Start date
  • Tags Tags
    Excel Histogram
Click For Summary

Discussion Overview

The discussion revolves around the possibility of creating histograms in Microsoft Excel, exploring various methods and tools available within the software. Participants share their experiences and suggestions regarding the use of Excel's charting features for this purpose.

Discussion Character

  • Technical explanation, Debate/contested

Main Points Raised

  • One participant inquires about the availability of histograms in Excel, noting the absence of a specific histogram option in the toolbar.
  • Another participant suggests accessing histograms through the "other charts" option.
  • A different participant proposes using the Insert -> Columns method along with the frequency function to create histograms and perform statistical analysis.
  • One participant counters that the suggested methods are unhelpful and mentions that histograms may not be available in Excel without installing an add-in, referencing information found online.

Areas of Agreement / Disagreement

Participants express differing views on the availability and methods for creating histograms in Excel, indicating that there is no consensus on the best approach or the necessity of add-ins.

Contextual Notes

Some participants' suggestions depend on specific versions of Excel or may require additional tools, which are not universally applicable. There is also uncertainty regarding the need for add-ins to access histogram functionality.

manjuvenamma
Messages
102
Reaction score
0
Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.
 
Physics news on Phys.org
click on "other charts"
 
You can use Insert -> Columns for histograms. Together with the matrix function {=frequency()} (with contr, alt, enter) you can work out some decent statistics.
 
"other charts" or "columns' is of no help. But I read on the net, histogram is not available with Excel as it is, you have to install some add-in.
Thanks for trying to help.
 

Similar threads

Is it okay to add error bars into a histogram plot?
  • · Replies 10 ·
Replies
10
Views
3K
LaTeX How to Create a Histogram in Latex: Step-by-Step Guide
  • · Replies 1 ·
Replies
1
Views
4K
MATLAB Creating a Histogram with Data from a File.dat in MATLAB
  • · Replies 12 ·
Replies
12
Views
2K
Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
4K
Python Help with Histogram and Boxplot in Python
  • · Replies 3 ·
Replies
3
Views
2K
Mathematica Simple Histogram using Mathematica - please
  • · Replies 2 ·
Replies
2
Views
6K
Mathematica Changing interval in Histogram, Mathematica
  • · Replies 1 ·
Replies
1
Views
7K
Graduate Summing simple histograms to recreate a more complex one
  • · Replies 2 ·
Replies
2
Views
1K
Engineering Do Identical Histograms Remain the Same After Applying a Smoothing Mask?
  • · Replies 2 ·
Replies
2
Views
5K
MATLAB Histogram coloured by different hues in matlab
  • · Replies 1 ·
Replies
1
Views
2K