![]() ![]() On the Excel "ribbon", I click Data > Data Analysis > Histogram and fill in the dialog box as shown.Ĥ. I enter 1, 2, 3, 4 and 5 into B1:B5 (my bin identifiers).ģ. So I make a few "adjustments" to the DA Histogram results in order to get the results that I want for presentation purposes. (Note: I am not adept at using the Data Analysis tool. The following creates the "histogram" chart using the Data Analysis tool - if that is the distinction that you are trying to make. Or perhaps it is a limitation (!) of your version (and ?) of Excel.įirst, according to the MSFT help page "Create a histogram": `` A histogram is a column chart that shows frequency data.`` There is no difference, AFAIK.īut you are correct: _I_ created a Column Chart directly from the frequency data. That seems to be a distinction without a difference. ![]() I suspect that you have been looking at regular column charts were made that look like histograms`` Wrote: ``As for as I know you can not add a trend line to a histogram. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |