Changing Horizontal axis ranges in Histograms

Question

I need to compare two sets of data, making a histogram for each, as part of my mathematics assignment. The data is very similar except the highest value on one is one number higher than the other. They both reach 0 but one goes to 12 while to other goes to 13. To accurately compare the results using histograms, I need the ranges to be the same. Currently a's ranges are; 0-2, 2-5, 5-7, 7-10, 10-12. b's ranges are; 0-3, 3-6, 6-8, 8-11, 11-14. Is there a way I can change a's ranges to the same as b's and have the data still accurately represented?

Answer 1

Well, yes and no... depends on what you expect.

Both ranges have 5 categories, if the histogram should show the amount in each?

Show us a data sample, at best a sample file.

Andreas.

Answer 2

a's scores
3
6
6
6
6
7
6
7
6
7
0
6
6
6
4
6
6
6
7
1
6
6
6
6
6
6
12

b's scores
6
7
6
0
6
6
6
7
6
6
6
6
6
6
6
6
6
0
6
4
6
6
7
1
7
4
13

Answer 3

A long, long time ago . . .  I wrote an add-in called Better Histogram. Here's an example of its results:

The add-in ZIP file is available for download at

https://treeplan.com/download/#Better-Histogram-Add-in

Answer 4

Excel can do this for you - you need the Analysis ToolPak add-in available. 

First install the add-in:

File->Options->Add-ins

down the bottom make sure the dropdown says Manage Excel Add-ins and click go

Tick the Analysis ToolPak and click OK.

Now in Excel, on the Data tab, Analysis group, click 'Data Analysis', select Histogram and you will see a form like below:

The input range is the data (either Scores A or Scores B). The bin range you can define with a series of from and to, although Excel is only interested in the 'To' value, and it counts values in each bin up to that 'To' value. The lowest bin automatically counts from the lowest value up to the 'To' value.

Indicate where the output is to go (a range, a new worksheet or a new workbook) and click OK.

The inputs and output (in G3:H9) from this example shown below.

Answer 5

What about this solution?

Here is a sample file:

https://www.dropbox.com/s/liir8g15n5lcd7g/c2d2a44d-a1d7-4c4d-b487-3d88a52da9f5.xlsx?dl=1

Andreas.