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?
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!
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |