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



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.






.



Relevant Pages

  • Re: Create Status Chart for projects
    ... Delete the vertical axis, since it's really meaningless. ... green...it's charted against the greens status...and when project yellow ... Make three lists, for Good, Medium, and Bad. ... Is there any way to put them in bar or pie chart. ...
    (microsoft.public.excel.misc)
  • Re: chart help
    ... Select the XY chart type, and the subtype with points and lines ... double-click the Y axis. ... > I am trying to create a chart which lists dates on the Y ...
    (microsoft.public.excel.worksheet.functions)
  • Re: OWC11 GroupingTotalFunction Invalid Parameter
    ... yup just ungroup and apply the correct formula using the enums. ... because it may refer to the wrong axis ... >>>>> arrays contain data about how many hours an employee logged for the ... >>>>> the chart displays the first two arrays in a stacked bar graph, ...
    (microsoft.public.office.developer.web.components)
  • Re: xy scatter - dates off
    ... Select the data for List A, create an XY chart. ... If you can't fix your problem by adjusting the X axis scale, ... Jon Peltier, Microsoft Excel MVP ... Although all 3 lists end at the year 2007, ...
    (microsoft.public.excel.charting)
  • chart help
    ... I am trying to create a chart which lists dates on the Y ... axis and numbers on the X axis. ... it puts the dates on the X axis....If I ...
    (microsoft.public.excel.worksheet.functions)