How to plot a pre-binned histogram in Excel 2007, without Analysis Toolpak -


I have two columns of data in Column A. There are values ​​in column A column A of each value connected to the box ( Therefore, say 1 to 10 cans) Example:

  AB ------ .43 1 .29 4 .23 1 .118 ... ...   

Is it possible to create a histogram chart with the Analysis tool without using the pack and ideally it does not need to post this data in frequency calculation?

The answer is to use a pivot chart, in this way I do not need to use Analysis Toolpac And I do not need to treat the data. Can be used as data.

Comments