Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I've created a Scatter Chart in OWC11 in C# and the X axis must display dates instead of numbers, I do it using the code below: .... string x= "10/2/2004 12:00:00 AM\t10/2/2004 12:00:00 AM\t10/5/2004 12:00:00 AM\t10/5/2004 12:00:00 AM\t10/6/2004 12:00:00 AM\t10/7/2004 12:00:00 AM\t10/8/2004 12:00:00 AM\t"; string y = 1\t2\t76\t67\t...."; objChart.SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimCategories , (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, "Scatter Charts Series 1"); objChart.SeriesCollection[0].SetData (OWC11.ChartDimensionsEnum.chDimXValues, (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, x); objChart.SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimYValues, (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, y); .... whe I do this, somehow the X axis doesn't display the current dates in the variable x and so the points position is wrong... so what I did is to change the dates in the x variable into numbers. That way did work out but it didn't display the dates in the x axis... (Example below) .... x= "5\t7\t78\t23\t23\t85\t...."; y = 1\t2\t76\t67\t...."; objChart.SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimCategories , (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, "Scatter Charts Series 1"); objChart.SeriesCollection[0].SetData (OWC11.ChartDimensionsEnum.chDimXValues, (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, x); objChart.SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimYValues, (int)OWC11.ChartSpecialDataSourcesEnum.chDataLiter al, y); .... I have no clue about using a Scatter Chart with a date format axis... can you please tell me any way to do that please? pavr1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter Chart Axis as text C# | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |