Reorder axes

[amarsah]

I fill an owc chart with 2 or more series, depending of recorset data,
"X" axis shows dates, I have a problem when i'm filling it, if the first
serie data have may and june data, and the second serie have april,may
and june, april categories appers at the end of the axis. How can i
reorder categories?

 

[Terri Pecora]

I had this problem and I had to manipulate it to have the
same months in both. So try adding a blank April.
Thanks
Terri

 

[amarsah]

Thanks Terri,

This solution works, another question, which value can I use as blank,
if I fill it with null, chart does not take it as blank and take then
next not null value, i do not want to fill it with zeros because they
are showed in the chart.