tourcd
IS-IT--Management
- Dec 5, 2005
- 37
Hi,
I have an Excel sheet with two columns, DATETIME and BYTES.
I'd like to chart this but alter the Y-axis scale to show the values in MB or GB. This has to be done without altering the raw data or adding additional columns etc.
So an example row is:
05/05/2013 00:00 742436864
So in the above example the bytes value translates to 708MB. I can easily alter the number format by shifting the decimal place but dividing by 1000 is not the right answer as there's 1024 bytes in a megabyte.
Does anyone have any ideas on this?
Many thanks.
I have an Excel sheet with two columns, DATETIME and BYTES.
I'd like to chart this but alter the Y-axis scale to show the values in MB or GB. This has to be done without altering the raw data or adding additional columns etc.
So an example row is:
05/05/2013 00:00 742436864
So in the above example the bytes value translates to 708MB. I can easily alter the number format by shifting the decimal place but dividing by 1000 is not the right answer as there's 1024 bytes in a megabyte.
Does anyone have any ideas on this?
Many thanks.