I want to convert KB, MB, and GB to one unit so I can display a chart.

[turtle328]

I want to make a hidden sheet where I can show how RAM has increased over the last 3 decades, then make a chart out of it. Here is my spreadsheet, what formula would I need to apply to accomplish this? I am very new to excel so I'd appreciate all the help I can get! Thanks!
exceldata.PNG

[shirleyxls]

You could create a row (then hide it) beneath your data and convert all your values into MB

128KB = 0.128
16MB = 16
1 GB = 1000
8 GB = 8000

then base your chart on this

[turtle328]

What a simple solution! Thanks! :D

[shirleyxls]

My pleasure!

Don't forget to mark this as SOLVED

Excel is a constant learning process and it's great to help each other. If I've helped you today, a click on the star on the left is appreciated.