Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
DuffyD
 
Posts: n/a
Default OWC.CHART - Why does my X-Axis come out in the wrong order - somet

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM
y axis on wrong side Bill H. Charts and Charting in Excel 2 January 7th 05 02:31 PM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"