+ Reply to Thread
Results 1 to 2 of 2

Histogram Charts in Excel 2016

  1. #1
    Registered User
    Join Date
    03-26-2009
    Location
    Big Town, Texas
    MS-Off Ver
    Excel 2003
    Posts
    47

    Histogram Charts in Excel 2016

    Quick question - does anyone know how to edit the x-axis of a histogram chart so that the data bars drop in-between values? I'm ultimately trying to create a x-axis that just has one value per tick mark instead of a range (i.e. 1%, 3%, 5%, etc instead of 1%-3%, 3%-5%, etc). Any help is greatly appreciated.

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: Histogram Charts in Excel 2016

    The new histogram will have bins rather than discrete groups. Even if you increased the number of bins so each covered 1% the axis label would be 1% - 2%. Or change bin size to 0.01

    I think you need to use a pivot chart, column style, where the discrete values will be counted.
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 23
    Last Post: 01-03-2022, 10:45 AM
  2. [SOLVED] VBA and Excel 2016
    By Saturn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2016, 12:35 PM
  3. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  4. Excel 2016 & beyond!
    By jewelsharma in forum The Water Cooler
    Replies: 6
    Last Post: 01-10-2016, 05:53 AM
  5. Powerpivot in excel 2016
    By Poperick in forum Office 365
    Replies: 0
    Last Post: 10-19-2015, 07:03 AM
  6. [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
  7. 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

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