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

D

DuffyD

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.
 
A

Alvin Bruney [MVP]

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
 
D

DuffyD

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
A

Alvin Bruney [MVP]

It is not possible to ungroup OWC version 9.
but every once
Click to expand...

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 said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
D

DuffyD

Alvin, The data itself is correct, for each given date-- meaning that on each
date it plots the data on the correct y axis. Unfortunately, it orders the
dates incorrectly on the x-axis.

Alvin Bruney said:
It is not possible to ungroup OWC version 9.
but every once
Click to expand...

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 said:
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 said:
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
-------------------------------------------------------


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.
Click to expand...
Click to expand...
Click to expand...
 
A

Alvin Bruney [MVP]

I'd suggest you open a support ticket with Microsoft. If you possess a valid
copy of Microsoft Office 2000, you are entitled to 3 free support tickets
(no cost).

--
________________________
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 said:
Alvin, The data itself is correct, for each given date-- meaning that on
each
date it plots the data on the correct y axis. Unfortunately, it orders
the
dates incorrectly on the x-axis.

Alvin Bruney said:
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
Click to expand...

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 said:
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!



:

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


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.
Click to expand...
Click to expand...
Click to expand...
 

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

Gantt chart duration not showing 0
Print order of TriFold - Publisher 365 0
Doughnut Chart linked with the slicer in the pivot table 0
Finding asymptote equation and how to draw them in excel 0
Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
OWC.CHART - Why does my X-Axis come out in the wrong order - somet 0

Top