How to set the format for the data in the Charts Categories

N

Nick Palmer

Hi all,

Is it possible to tell the OWC Chart what the format of the data is supposed
to be for the Categories. I ask because one of my Categories is Time, which
I'm guessing is pretty typical and I am setting the values to "Jan 2003"
and "Feb 2003" etc ... But what I get in my chart is 1/1/2003 and 2/1/2003
etc ... So it appears that the OWC chart is interpreting my values as real
dates and formating as such. I have tried putting a single quote " ' " in
front of each value and this gives me just my text, but I also get the
single quote which I would rather not have.

Has anyone run into this problem, and if so, how did you solve it ?

Thanks in advance,
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
How to getting text labels to show up in scatter chart. 0
Excel does not accept text format! 0
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Getting the state of a chart. 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
OWC chart. Categories=dates 1
VBA - exporting serial letters to single documents 0

Top