Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.

Alvin,
It seems that we are using owc9 on our server, and I have been searching all
over google for ungrouping for owc9. Since I have a copy of your book... is
this information in your book? If so, any idea what page it is on?
Thanks for your help!



"Alvin Bruney [MVP]" wrote:

You should just ungroup the axis, that will fix it. There's code in here to
do just that if you google. Ungroup is preferred to the hacky "~"
replacement.

--
________________________
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
-------------------------------------------------------


"DuffyD" <DuffyD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F93C059-A7D0-4ABE-B4E4-31068C93EBF8@xxxxxxxxxxxxxxxx
Since I am new to this site, I am posting my question in a couple of
different areas.
**********************************************************************
I have been searching the web for help on this... and other people are
experiencing this problem as well, but I can't find a solution that works.

Basically, I am using asp and OWC.Chart to create a chart. I am running a
SQLServer query, and sorting my data in the order that I want it displayed
in
the graph, then sending it to OWC.Chart to be displayed.
cht.Type = c.chChartTypeLine
This Chart should have multiple lines plotted on it for each of the
different products, and it is set over a date range on the x axis.

Most of the time, it lists the dates in the correct order, but every once
in
a while, it lists the dates on the X axis in the incorrect order. I have
searched all over google for other people having problems with this, and
most
of them say that the it is a "date" problem... convert the "/" to a "~"
(Alvin Bruney), or convert from "Date" to "varchar", etc. This doesn't
seem
to work. Others have said to reverse the order of the sort in my SQL from
ASC to DESC. This doesn't seem to work either.

On one of the sites, there is the comment "It interpolates dates for the
data that do not exist, and moves the =provided data values to actually
different dates!", but I have no idea what kind of solution to use for
this.

If anyone has any ideas that will help me to get the X-axis to come out in
the correct order... I would appreciate it.




.

Relevant Pages

  • Re: trickler3103.exe
    ... It's hard to tell for sure what a file is by the file name, but searching ... If you still can't download it, some versions of windows will let you run ... google or download.com to find it]. ... > I cannot delete or uninstall it. ...
    (microsoft.public.security)
  • Re: trickler3103.exe
    ... It's hard to tell for sure what a file is by the file name, but searching ... spyware application that installs along with programs like "Gator" [which is ... If you still can't download it, some versions of windows will let you run ... google or download.com to find it]. ...
    (microsoft.public.security)
  • Re: Why Google is a pile of shit
    ... But why does it boast about returning 6 million possible pages when I only ... Why should businesses agonise over changing Google algorithms every three ... My main criticism of Google is that it is crap at searching. ...
    (uk.politics.misc)
  • Re: Building a Bitness Analyzer
    ... People can do Google searches. ... > engines for searching the archived records. ... appearance to the rest of the world that the Borland Developer Community is ...
    (borland.public.delphi.non-technical)
  • Re: Gaggia Coffee Deluxe : leaking boiler Q: "and newbies to the Internet"
    ... I did do some searching via google but did ... not find the ultimate link you referrence, which does indeed, ... > methodology used in order to get answers on the deja.com and google. ... for instance "gaggia leaking" and search for it. ...
    (alt.coffee)