What property or ? I need to set in order to align dates with the tick marks on the x Axis
My dates are appearing in between the tick marks and I want them to appear under the tick marks
Right now I get the following
| | |
3/1/2006 3/8/2006
What I want the graph to display is:
| | |
3/1/2006 3/8/2006
I can make it happen in excel but I can not find the property so I can set via a script
I really would appreciate anyone who can help me
Here is sample script (javascript) that creates a graph and set the date in between ticks
Expand|Select|Wrap|Line Numbers
- ..
- var oChart;
- var oSeries;
- var oLabels;
- var c ;
- var vYAxis = new Array("05-Nov","06-Nov","07-Nov","08-Nov","11-Nov");
- var vXAxis = new Array(150,125,80,140,134);
- document.all.ChartSpace.Clear() ;
- c = document.all.ChartSpace.Constants;
- oChart = document.all.ChartSpace.Charts.Add();
- oChart.HasTitle = true;
- oChart.Title.Caption = "Inventory";
- oChart.Type = c.chChartTypeLineMarkers;
- oChart.SeriesCollection.Add();
- oChart.SeriesCollection(0).Line.Color = "Red" ;
- oChart.SeriesCollection(0).SetData(c.chDimCategories, c.chDataLiteral, vYAxis);
- oChart.SeriesCollection(0).SetData (c.chDimValues, c.chDataLiteral, vXAxis ) ;
Thank you
Frank