I'm working on a spreadsheet that gathers data directly from the Bloomberg service on historical pricing information for commodities. I have made a line chart which takes indexed values from two different commodities (ex. cells tab1!F6:F400, tab2!F6:F400).
The problem that I have encountered is that since the Bloomberg system will leave non-trading days as blank values, the chart is including certain days with the value of zero. I want to either be able to conditionally hide rows where the cells in column G have no value, or to be able to have the chart ignore the cells that have no value in the range selected.
Note: I have very little knowledge of VBA, so if you have a VBA solution, I would really appreciate an explanation of how to do it.