Hi everyone - I'm new to this forum and am hoping someone can help me with an Access issue that I can't find an answer to. I've spent two days googling various sites to try and find a solution, and I'm starting to think there isn't one... fingers crossed that someone can give me a hint
My Googling has turned up that, In the Excel standard chart wizard, it's quite easy to ignore zeros in data when plotting a line graph. Also I know that when creating an Excel Pivot Chart, you can ignore zeroes by changing them to "#N/A"
The Access standard chart wizard is pants, so I am using the Access Pivot Chart function. Basically over a year, some percent data is not available for a few months. What I want is the line to "stop" at the last point on the chart and not fall down to zero percent.
Since Access tables do not recognise #N/A as a valid number, I am starting to think it's impossible. What I can't believe is that nobody in the world has asked this question before (if someone can point me to another thread with a solution, I will eat my hat!)
Thanks for any help, and hi by the way!
James