Skip to main content

Posts

Showing posts with the label Remove

Remove Empty Music Tracks Created by Media Provider in Dev Tools of Custom Android ROM

For Pros : The solution is to reset the Data of ‘Media Storage’ under App Settings. For Others : Please tolerate the pain of reading through my post. I installed CyanogenMod custom ROM in my Sony Ericsson WT19i a couple months ago. Rest of my experience with my phone after that has been simply a honeymoon. Until I messed up with this option called ‘Media Provider’ under ‘Dev Tools’ in CyanogenMod. Media Provider is used to simulate music tracks in your music player. After tapping the ‘Insert 20 Albums’ it created some 20 tracks (as expected) with satanic Latin names. At that time I had two music players – Apollo and Google Music, both of which reflected these ghostly tracks and often irritated by interrupting the playlist. Every time I had to skip the tracks manually. After a deep web search I found the solution to remove the tracks. You may not find the audio files anywhere in your SD Card (But some people have removed it by deleting files inside a folder called ‘Media’. But le...

How to remove zero values from Office Excel graph / chart?

  No matter in version of MS Office you are working with, this simple trick will always work. Lets get to the topic straight. Here is a table I have for which I need to draw a graph. We have zero values for two cities - Narnia and Atlantis (Assuming that everyone is wiped out in zombie apocalypse). City Population in Millions Chennai 243 Bangalore 527 Narnia 0 Atlantis 0 Mumbai 457 Delhi 23 Kolkata 10 Here is the typical graph we generated in excel for the above table. One thing that looks un-presentable in this chart is the zero values at the bottom of the pie chart. Here are the steps to remove the zero values. Right-click on any of the data labels (the numbers representing the population here) and select Format Data Labels . A Pop-Up for Format Data Labels will open. In that navigate to Number tab. In Number tab under Category , select Custom and enter the Format Code as below 0;;; Click Add and Close the window. Now your graph will ...