2 Replies Latest reply on Aug 13, 2017 11:40 AM by Lisa Schnellinger

    How to create bins from US Census age groupings?

    Lisa Schnellinger

      I'd like to make histograms and pie charts with US Census data for age.

       

      The data is supplied in percentages that total 100, by fields with pre-determined age groupings (e.g. 25 to 34, 65 to 74); I have added some additional groupings with calc fields.

       

      How can I make bins from this data so that I can create a histogram? Or take the portions and turn them into a pie?

       

      In the attached workbook (Desktop 10.3.1), I have made a stacked bar graph in the Age Portions worksheet. I'd like to use that data as a pie chart or histogram.

       

      Grateful for any help.