Quote:
Originally Posted by Katie Reynolds
So, this project I'm working on shows the percentage of reports submitted each month that are successful.
However, for some months, no reports are submitted, so there is no data. It doesn't really make sense to record it as 0% or 100%, since the month wasn't a total failure or totally successful. And it also doesn't make sense to show it as somewhere in between the months on either side, because that's not correct.
Ideally, the line would just stop at the previous month and start back up again at the next month.
Does anyone know a way to do this?
(I have my empty cell set as =NA(). And in the graph settings, I have "Show Empty Cells As:" set to "Gaps". I'm using Excel 2007)
|
The attached was created in Excel 2010 and it does what you're after automatically. Perhaps see if you can copy the attached graph into your workbook and link it to your data... You never know, Microsoft might stun us all and have something actually work well!!