a histogram witha visible bar even though the category is zero

User avatar
stuck
Panoramic Lounger
Posts: 8176
Joined: 25 Jan 2010, 09:09
Location: retirement

a histogram witha visible bar even though the category is zero

Post by stuck »

I have a histogram where many of the bars have zero height. As expected these bars are not visible on the histogram but I'd like to be able to see something, if only a very thin line, i.e. show that the emptiness means 'zero'.

Any ideas??

Ken

User avatar
stuck
Panoramic Lounger
Posts: 8176
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: a histogram witha visible bar even though the category is zero

Post by stuck »

OK, as usual typing out the question helps me figure out what it is I want.

If I delete the x-axis and then artificially inflate a zero value to a small value, e.g. 0.05, I can see the now non-zeros are visible as a thin line. The y-axis scale on the histogram is great enough to make it impossible to see 'zero' is actually being plotted as 0.05.

I think this will do the job, for now.

Thanks for listening.

Ken

User avatar
BobH
UraniumLounger
Posts: 9284
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: a histogram witha visible bar even though the category is zero

Post by BobH »

Is this in Excel? If so, can't you manipulate the starting value of the y-axis to cause values below zero to appear? I seem to recall having done that in the more than 20 years ago before I retired.
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs