When I right-click the series (one column in the chart), I get the following menu, which includes the Add Trendline option.Ħ. Note the Chart Type - Column - after I right-click the series (one column in the chart) and click Change Series Chart Type.ĥ. After I click OK and make a few 'adjustments' (hacks !), the result is:
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.
