Hi All,
I am trying to hide columns in a range of data to get around the problem of my chart showing 8 potential lines on a line chart rather than 2-3 (depending on the data available).
I have done some searching and this code works for me to hide a single column:
However, i'd like to also apply this to Column G when "C4" is 0, and Column H when "D4" is 0 etc.
I tried to just copy and paste the code and make the changes but it wont allow me. I am using the code in the command window of the sheet so that Excel auto-calculates it each time, this way my chart will be dynamic on the screen.
Can anyone suggest how I go about this? - I am not too familiar with VBA but trying to get onto a course (when it comes to loops and EndIfs etc, I get easily confused!)
Thanks,
Simon
Bookmarks