BookmarkSubscribe
Choose Language Hide Translation Bar
ab0716
Community Trekker

How to create a distribution graph with empty bars

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?

 

Capture.PNG

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to create a distribution graph with empty bars

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.

Jim
1 REPLY 1
txnelson
Super User

Re: How to create a distribution graph with empty bars

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.

Jim