Chart - lowest value sits at zero (looks like)

I have a chart.  The chart works fine except the lowest values seem/look like they sit at zero(0).  They are NOT zero (Man hours - in my example below)!  How do I bring them up - meaning see them in the chart like the other two?

 

Tiger1_0-1743433545767.png

 

0 2 65
2 REPLIES 2

In general it sounds that the values of 'Revenue" and 'EBITDA" are numerically much higher than "Man Hours" . if so, naturally plotting  those in the same chart will not work.

You could use a few workarounds to bring it up.  You may want to divide 'Revenue" and " EBITDA" values by say 1000 in separate VCs called say [Revenue_V] and [EBITDA-V] Then you could have display name for those columns as "Revenue in 1000s" and "EBITDA in 1000s" or something similar.

So a revenue of 6000,000 will just show up as 6000 in the chart ( of course it is a K value , that is 6000 K) Now if the "Man Hours" are comparable in at least some 1000s , then those will start showing up.  If the 'Man Hours" are still miniscule then instead of 1000s (K) you may need to show "Revenue", "EBITDA" in millions ( divide by 100,0000)

Thanks for this advice.  I will try this way.  Thanks so much!