Horizontal Category labels - one character wide?

[Ben Holko]

I have a line chart (owc11) with a few thousand entries. I have set
ticklabel spacing to 300, so it only shows me about 8 ticklabels,
which is what I want.

I have set the ticklabel text orientation to horizontal.

However, OWC seems to be using ALL category labels to calculate that
it cant fit the labels horizontally, so it's placing the text
horizontally, but it's only one character wide.

where my label should appear as:

06:23_PM

it appears as

o
6
:
2
3
_
P
M

How can I tell OWC to ignore the category labels that it is not
displaying?

That's question 1, now for question 2:

My category labels are datestamps from an ADO recordset. OWC seems to
think they're all the same, because if my category array is made up of
the "native" datestamps, the graph only renders one value. Obviously
OWC is treating them as dates, and thinks they're all the same (maybe
because they're all the same year?) There is a new category/value
approximately every minute.

To get it to work, I have to split the datestamp, and use something
like "06:23_PM" (note the underscore, which is necessary to get it to
work).

I have tried converting the datestamps to strings in both VB and SQL
(using CAST) but nothing seems to work.

Is there a way to get OWC to run with all the category labels even if
they are (or are considered to be) the same?

Ben

 

[Alvin Bruney [MVP]]

For 2
turn of time scaling on the category axis and remove the _PM in your code.
OWC time scaling is on by default and can sometimes be a bother.

For 1
hmmm....
If you follow my suggestion for question 2, it rules out the possibility of
an answer for question 1. So you could keep your solution for question 2 and
adjust the ticklabelunittype so that you have less values per axes