Setting CetegoryType in C#

[Preben Zacho]

Is that possible in C#. In VBA you can fx. set category type to
xlCategoryScale, but I can't seem top find that property in C#.

I assume it's scaled using xlAutomatic. So, my X-axis categories are dates
alright, but there are holes in the timeline (sometimes 3 days, sometimes 6
days) and the result is that the chart gets "confused" and print out
irregular values for the dates that are NOT specified.

I really need to set it to xlCategoryScale (if possible), which I think will
fix it.

Regards,

Preben Zacho

 

[Alvin Bruney [MVP]]

I don't think that setting is brought forward to OWC, you may want to search
MSDN for null data points and owc. There is a handle article that shows you
how to setup your code so that owc does not get confused with missing data
points.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[Preben Zacho]

Don't worry, I've already solved it. I simply put a none-printable ASCII
char in front of the text and the automatic setting of the axis will no
longer assume that this is a timescaled axis.

Regards

PZ

I don't think that setting is brought forward to OWC, you may want to
search MSDN for null data points and owc. There is a handle article that
shows you how to setup your code so that owc does not get confused with
missing data points.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Is that possible in C#. In VBA you can fx. set category type to
xlCategoryScale, but I can't seem top find that property in C#.

I assume it's scaled using xlAutomatic. So, my X-axis categories are
dates alright, but there are holes in the timeline (sometimes 3 days,
sometimes 6 days) and the result is that the chart gets "confused" and
print out irregular values for the dates that are NOT specified.

I really need to set it to xlCategoryScale (if possible), which I think
will fix it.

Regards,

Preben Zacho