Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
y axis on wrong side | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |