Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot

0 votes
I am trying to give specific bins on my histogram plot different bin widths. Is there a way to say I want bin 1 to have a width 1-10 and bin 20 to have a width of 300-1000?
Oct 1, 2022 in Others by Kithuzzz
• 38,020 points
1,852 views

1 answer to this question.

0 votes

Excel built-in histogram tool only allows equal bin-width. We must create instead a "variable width column chart" as explained by Jon Peltier. This can be a tedious and error-prone process if you've got a lot of bins. Video tutorial for Excel 2016. The main steps are as followed:

  1. Create a cascade table:

Input table

should turn into:

Cascade table

Note: dummy + Label columns aren't required, but help with labeling

  1. generates a stacked area chart (a type of Area chart)

stacked area chart

  1. Then change the Primary Axis's category to Time-Scale to straighten the areas into bars. As explained by Jon Peltier, this is because:

This is somewhat misleading, as Excel time-scale axes only consider dates and ignore times.

straightened columns

answered Oct 2, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,720 points
624 views
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,335 views
0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,720 points
1,128 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,106 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
1,026 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
4,309 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,185 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,720 points
1,951 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP