Constructed a waterfall chart with column labels "blank", "up", and "down". The down column will return a positive label (-MIN(cell reference)) and I want it to show as a negative on my chart. How do I do this? The value in the cell cannot be negative as it will just drop below the x-axis and throw off my charts. I want everything to remain the same and just throw some parenthesis around all my down values on the chart labels. Is there a VBA macro that will allow me to do this? Thanks in advance...
Bookmarks