+ Reply to Thread
Results 1 to 3 of 3

Trying to make a histogram following https://trumpexcel.com/histogram-in-excel - help

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    New Mexico
    MS-Off Ver
    2010
    Posts
    52

    Trying to make a histogram following https://trumpexcel.com/histogram-in-excel - help

    So I'm trying to follow these basic instructions and am lost within the first steps. When I select the "insert" tab, I cannot find ANYTHING called "static chart". Yes, there are images that look similar to the ones shown, but they are not titled anything close to "static". There are 72 chart forms to choose from (yes - I COUNTED). I've checked every single individual one. I'm sure one is the one I'm looking for, but none are called "static". This is extremely basic stuff, yet I can't figure it out. Please help. This is what I'm looking at - https://trumpexcel.com/histogram-in-excel

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Trying to make a histogram following https://trumpexcel.com/histogram-in-excel - help

    Your profile says that you are using Excel 2010. The instructions at trumpexcel that involve finding the "static chart" are for Excel 2016 only. The tutorial explains that, if you are using any Excel version earlier than 2016 (including 2010) that you should either use the Data analysis toolpak addin or use the FREQUENCY() (or other counting function) to summarize the data and build the chart as a column chart. Be sure you are using instructions appropriate to your version of Excel.

    (If your profile is incorrect and you are using Excel 2016, it would be helpful to us to update your profile so we can give help relevant to your actual Excel version and not the version you were using when you first joined the forum).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-11-2018
    Location
    New Mexico
    MS-Off Ver
    2010
    Posts
    52

    Re: Trying to make a histogram following https://trumpexcel.com/histogram-in-excel - help

    Wow, thanks. Pretty sure that explains it. I never "set" my version, I think it just auto detected when I joined the site and I'd have never guessed it was the older one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Histogram - One giant bin, can't make more.
    By Mr. Friscus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2017, 07:31 PM
  2. [SOLVED] I was creating a histogram; now i have data but no histogram.
    By ShannonMills3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-13-2006, 07:10 PM
  3. [SOLVED] How to Histogram w/o raw data but histogram Table on Excel
    By 2005 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2006, 02:50 AM
  4. how to make a histogram with frequency
    By hannah553 in forum Excel General
    Replies: 1
    Last Post: 01-15-2006, 02:10 PM
  5. [SOLVED] Make Histogram and Normal distribution.
    By Ed (from UK and useless with comuters!) in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-19-2005, 02:10 PM
  6. Need to make a plain barchart, not a histogram
    By penguinchick in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2005, 07:05 PM
  7. [SOLVED] How to make excel not round real numbers when making a histogram?
    By Leedawg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1