Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- From: "Alvin Bruney [MVP]" <www.lulu.com/owc>
- Date: Mon, 26 Jun 2006 20:29:48 -0400
It is not possible to ungroup OWC version 9.
but every once
in
a while, it lists the dates on the X axis in the incorrect order
For these charts, have you eliminated the data as the problem first?
--
________________________
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:614C4A73-01D0-4C52-9C46-7DE85B2A35D9@xxxxxxxxxxxxxxxx
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.
.
- Follow-Ups:
- References:
- Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- From: Alvin Bruney [MVP]
- Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- From: DuffyD
- Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- Prev by Date: Re: Probability plots using OWC10
- Next by Date: Re: Cannot set Spreadsheet.XMLData in WinForms
- Previous by thread: Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- Next by thread: Re: OWC.Chart and ASP. X-Axis on chart displays in wrong order.
- Index(es):
Relevant Pages
|