How to create a distribution graph with empty bars

Question

Hi, I am making a distribution based on one of my columns. It plots the frequency that each number shows up in my table. But I also want to display other numbers with blank bars, because that will show the whole picture of what I want to display.

For example, in the picture below I manually added number 5233333 and it shows up on my graph. How do I make the label stay there, but have the bar disapper, so there is a blank spot on my graph?

txnelson · Accepted Answer

Create a new column that has all rows equal to the value of 1, except for the category you don't want to have any bar displayed for.  Then when you run the histogram, specify the newly created column as the "Freq" column.