473,395 Members | 1,763 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Help with Office web components - Positioning axis labels

I am using OWC and have a problem that I would appreciate it if anyone could help me wih.
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
  1. ..
  2. var oChart;
  3. var oSeries;
  4. var oLabels;
  5. var c ;
  6. var vYAxis = new Array("05-Nov","06-Nov","07-Nov","08-Nov","11-Nov");
  7. var vXAxis = new Array(150,125,80,140,134);
  8.  
  9. document.all.ChartSpace.Clear() ;
  10. c = document.all.ChartSpace.Constants;    
  11. oChart =  document.all.ChartSpace.Charts.Add();
  12. oChart.HasTitle = true;
  13. oChart.Title.Caption = "Inventory";
  14. oChart.Type = c.chChartTypeLineMarkers; 
  15. oChart.SeriesCollection.Add();
  16. oChart.SeriesCollection(0).Line.Color = "Red" ;
  17. oChart.SeriesCollection(0).SetData(c.chDimCategories, c.chDataLiteral, vYAxis);
  18. oChart.SeriesCollection(0).SetData (c.chDimValues, c.chDataLiteral, vXAxis ) ; 
  19.  
..
Thank you
Frank
Oct 31 '06 #1
0 1584

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: farrell77 | last post by:
I have a pivot chart that displays 3 data series. Series 1 values range from 17 to 106. Series 2 values range from 1 to 18. Series 3 values range from 0 to 1. When I display all three series...
1
by: srinivas | last post by:
Hi, I created an interactive html page by saving an excel file.What i need is, i created this file using office 2000.some of our clients are unable to access my page.when ever they attempt to...
7
by: John | last post by:
I'm trying to use the OWC on my web form and trying to make it look like Excel. I have the box there but no formatting such as headers, bold font, etc. I have the same control on a asp page and I...
5
by: Michael Russell | last post by:
Hi all, Using C#, I've created a simple wrapper class for using Excel. I have Office Pro 2003 installed on my devel machine. The wrapper class works great, reading and writing to/from Excel. ...
2
by: johnbkim | last post by:
I'm using JPGraph to plot temperature vs. time. Time is given as timestamps, so I use a callback function to print it as hours and minutes. Here's the graph and the code: ...
2
by: orfiyus | last post by:
Hi I am working on a script that that creates charts. So I decided to follow this tutorial using the chart director api. I more or less understand everything going on I just cant seem to find...
0
by: panam | last post by:
hi when i type the followind commands igot the error as under.. plz help me wats the problem.... C:\axis>java -cp %AXISCLASSPATH% org.apache.axis.client.AdminClient -lhttp://loc...
1
by: DBC User | last post by:
Hi all, I would like to see if it is possible to draw unrooted and rooted tree in c#, I checked the zedgraph and it is only like line, bar or chart not a free form graphs. Is it possible to do...
0
by: sudhaMurugesan | last post by:
I created a line graph. I found that X-axis labels direction are horizontally. So for long labels, it show two lines of label alternatively. When I put many labels in x-axis, it changes to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.