Charities have described how the Princess of Wales' cancer story has led to increased awareness on the disease, which has become known as the 'Kate effect'.