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!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks