Bar graphs...
I have a range of cells, which are in turn populated by formula driven
figures - but essentially just hold a number 0-50 at the moment. So there's a bar graph driven by this data, nice and simple - two axis, one with the various headers and the other for the totals. However there are ceveral cells which at the moment are 0 as there is no relevant data to trigger the formula. I've been asked if there's any way of setting up the graph so it will consider the whole range of information, but only display those cells which have a figure greater than 0, and also be responsive to the cells with 0 for when they finally get a figure? Cheers |
Bar graphs...
Hi,
If you hide the row containing zero, use Autofilter, the chart will automatically remove it. Just make sure the setting Plot visible cells only is checked. Select chart and use menu Tools Options Chart. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "GD" wrote in message ... I have a range of cells, which are in turn populated by formula driven figures - but essentially just hold a number 0-50 at the moment. So there's a bar graph driven by this data, nice and simple - two axis, one with the various headers and the other for the totals. However there are ceveral cells which at the moment are 0 as there is no relevant data to trigger the formula. I've been asked if there's any way of setting up the graph so it will consider the whole range of information, but only display those cells which have a figure greater than 0, and also be responsive to the cells with 0 for when they finally get a figure? Cheers |
All times are GMT +1. The time now is 09:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com