Convert MB to TB in Excel 2016

[shawnb86]

Hi I have data that I input in to a chart but the output is MBs and id prefer TB due to the large sizes of data. Could anyone help with a formula?

Thanks!

 

[macfuller]

Does it have to be a single line graph? You have such a variance in magnitude between platforms that the lines will be clustered at the top and bottom with no real separation. It may not even be worth putting 9 lines onto a single graph even if you gave each of them a multiplier to set their baselines to (say) 100 so their variance would show up. Would it be worthwhile to show what % of available space the numbers mean each day?

Sparklines might be useful for each of the platforms if you want the pure numbers.

Lets take your Domino platform - it goes from 199K to 76K and 2484K over the 3 days - the lines are going to be a mess if all the platforms vary that much. What is the "ideal" value for Domino? Would you want to show the variance from (say) 500K? Or for a cleaner look you might have an icon in the daily cells... no fill if the value is below 50% above your optimum (why clutter your visuals for days with good values), yellow if it's 50% above your optimum, red if above 80%. Or wherever you wanted to set your cutoffs. So days with heavy usage are immediately set off.

 

[mse330]

Why don't you just change the number format of the cells ? Try that by selecting your data range then Ctrl+1 then Custom then put this #,##0.0,, "TB" or you can remove the "TB" if not needed. Your data will remain as is but it will show in TB format