Hi,
I would like to know if there is a method by which I can chart the top 5 clients week on week, and all remaining clients as "other". I currently chart this weekly with all clients, so my chart can look quite busy - using Stacked Area. I've tried using filters but these numbers are also used as references to other parts of the sheet, so cannot hide them and Top 10 won't give me a summary of the remaining clients. I'm using excel 2007.
.............29-Jul.....05-Aug....12-Aug... etc
LONDON..123555...15563......11117
CAIRO.....0...........123333....0
PARIS.....999211....5667.......0
OSLO......1100.......43856.....7000
LUANDA...66610.....0............295611
TRIPOLI...88488.....147933....111
etc
Is it possible or will my boss just have to live with the current chart
I would like to know if there is a method by which I can chart the top 5 clients week on week, and all remaining clients as "other". I currently chart this weekly with all clients, so my chart can look quite busy - using Stacked Area. I've tried using filters but these numbers are also used as references to other parts of the sheet, so cannot hide them and Top 10 won't give me a summary of the remaining clients. I'm using excel 2007.
.............29-Jul.....05-Aug....12-Aug... etc
LONDON..123555...15563......11117
CAIRO.....0...........123333....0
PARIS.....999211....5667.......0
OSLO......1100.......43856.....7000
LUANDA...66610.....0............295611
TRIPOLI...88488.....147933....111
etc
Is it possible or will my boss just have to live with the current chart