开发者

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

开发者 https://www.devze.com 2023-02-20 12:47 出处:网络
I have two columns of data.Column A has values.Column B has bins associated with each value in Column A (so lets say bins 1 to 10).example:

I have two columns of data. Column A has values. Column B has bins associated with each value in Column A (so lets say bins 1 to 10). example:

A      B
--     ----
.43    1
.29    4
.23    1
.11    8
...    ...

Is it possible to create a histogram chart without using the analysis toolpak and ideally not having开发者_C百科 to post-process this data in frequency counts?


The answer is to use a PivotChart. In that way, I don't need to use the Analysis Toolpak AND I don't need to treat the data. The data can be used as-is.

0

精彩评论

暂无评论...
验证码 换一张
取 消