Moved the average series to secondary axis. Change the position of the secondary axis tick labels to inside (that's why it's showing on the left), and used [>1]General;;; as conditional format to hide the tick labels when the entire value in the series becomes NA() for the average as well as for the individual series.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi Excel Fox
Got all that to work except the used [>1]General;;; as conditional format to hide the tick labels when the entire value in the series becomes NA() for the average as well as for the individual series. Where do I perform this to hide the NA()
Thanks
Rich
Posting Permissions
Reply With Quote
Bookmarks