All,
Great Board...picked up loads of tips, as such my excel knowledge is getting OK...but I do need help with this one...as such thought I'd throw it out and see if anyone can help!
I have a list of companies with jobs outstanding (split by time). I want to show these jobs as stacked column graph...but if the total number of jobs is zero, then there is no need to show the column..hence remove it.
You can see from the attached that there are 25 companies, of which 10 currently have no jobs outstanding...how can I remove these.!
I'd appreciate not only an example spreadsheet, but also some idea of how you did it...as I've tried adapting a couple of other examples for removing zeros from pie charts with little success.
Thanks again
Niper
Bookmarks