Hello,
I have a chart that updates based on the drop down selection of accounts. The problem I am having is that some of the data is in percentages some in regular number format (wide range of numbers). The VBA seems to work for most of the data but when a selection is made were the data is percentages the lines on graph show up but the vertical axis is blank or has only one number at bottom like it can't scale percentages, it does the same thing for numbers below 0. Is there something I can add to my current VBA to correct this?
I have a chart that updates based on the drop down selection of accounts. The problem I am having is that some of the data is in percentages some in regular number format (wide range of numbers). The VBA seems to work for most of the data but when a selection is made were the data is percentages the lines on graph show up but the vertical axis is blank or has only one number at bottom like it can't scale percentages, it does the same thing for numbers below 0. Is there something I can add to my current VBA to correct this?