Hi guys
I'm creating some charts to show performance and have different coloured series depending on whether achievement was below 90%, 90-95 and >95%.
The problem I'm having is that I do need to plot zero values, but I don't want to plot #NA values - eg. July is 0%, Aug is 95%, Sept #NA and Oct 56% - I would like the line to miss out Sept and join Aug directly to Oct.
I've attached a simplified version to try and demonstrate the problem and would be glad of any input. I'd also be happy to listen to ideas of how this info could be better presented as I've a feeling it's going to look a bit messy once I add in another 2 full series of data...
Thanks
Bookmarks