I need to create a chart that queries two columns and ignores the rows when both are zero. Hopefully the attached example will be clearer.
I have attached a dummy dataset and two charts, one where I have got to and one where I would like to get. I've managed to auto filter and sort only the required fields and am trying to use named ranges in the chart, its just that last step I'm missing.
Any and all help is greatly appreciated.
Thank you,
Ed
Bookmarks