I've heard conflicting stories on the ability of Office Web Components to access a data source that resides on the internet (as opposed to the intranet). Some say you can, some say you cannot. I can get the owc chart to connect to my database on IIS but I would like to publish this on my webpage.I'd like to insert a chart on a page which I like to use data from an Access database on my webpage. How do I get that chart to link to a data source on my website? I use the following line to connect to my database normally:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("amsydb est.mdb"))
But where do I insert this in the data connection section so I can get my OWC chart to connect to this database?
I'm trying to develop some graphs for my site and hoped this would be a solution.
I have one question really. We've installed the MS Office 2003 components on our webserver -2003- but i seem unable to create a reference to it in the code i.e.
dim owc set owc = createObject("owc.chart")
It comes back with an error which doesn't seem to make sense as the component is registered on the server, does anyone know what might be causing this?
I ve created a table of information and now i need to make a number of pie charts from this table.
Ive attatched an image of the table, to make it easier for you to know what i mean. a pie chart i want to make for example is, say, the number of red,yellow and green projects in Fixed Income, ie 14 red, 4 yellow and 4 green.
I have been making a dynamic chart in ASP, and it's working fine so far. However there's only one thing that is not working. The color of Plotarea! I don't know how to define the color of plotarea. I tried to specify the color of Plotarea as below but it didn't work.
set oChart = Server.CreateObject("OWC.Chart") set objChart = oChart.Charts.Add() objChart.PlotArea.Interior.Color ="#FFFFFF"
what the best way to produce radar charts from asp would be? I know that I will probably need to install a component on the server. Any comments on what the best / cheapest one would be?
I have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ?? thank you very much
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
i have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
I prepare a owc chart in asp. in category axis (x-axis) i want to adjust date format according to date range, For Example: if data is of 5 years then tick lables show Years as below Large data : 2005,2006 Medium : Jan, Feb Samll : Mon, Tue
I've tried by NumberFormat property Chartspace.Charts(0).Axes(0).NumberFormat = "dd,mm,yy" but it is not working. can it be done through ASP or via SQL statement. if SQL then how
I have been asked that every user in the site should have a chart that shows individual calories, fat, carbs of items that the user selects in any restaurant so And the user would be able to plan how those items would effect their diet plan.
Also the charts and graphs will be for Weekly Progress Chart , as the site is for diet progress for the users.If anyone knows how this can be done,please help as i am stuck here and i am a newbie to ASP.
is there any component available for creating Organisation Chart. I hope, I don't have to write code for creating boxes & lines for creating this Org Chart.
I have made a page to display a chart based on data from my SQL-server. I have used Office Web-component graph. Here I can set the correct SQL statement and the graph works fine.
Now I want the user to be able to input the WHERE part of the sql sentence. Can anyone point me to info or code on the web to do this ?
I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see. Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
I need guidence regarding creation of PERT/CPM chart using technology ASP/PHP/VB. I just want to know if it is possible to create PERT/CPM chart using any of the above technology.
Anyone have code for a color chart. Specifically a chart that when clicked passes the hex value through querystring or a form. I could make one, but I'm just feeling lazy today.
any decent resources for using the Office Chart components? I've had a look around the MSDN but it's not very comprehensive and doesn't actually have any reference guides. Most resources say to refer to the help file that comes with the package but I can't find any versions of this.
I need to generate the line chart base on the value in the database. Do i need to use the chart control if i want to generate the line chart by using asp? Does anyone have a sample to generate the line chart cause i really don't have any idea of how to do it.
We need to create an org chart from our employee data but struglling. We are using ASP with SQL Server 2000. Does anyone know of a commercial component or some sample code to help us get started?
Ideally a component will be great as we need to turn this around quite quickly and also the chart needs to be interactive so various nodes can be hidden or expanded by the user. Many of you have been in development and I am sure would have been asked to present the employee or similar hierarchical data in tree structure.
I developed some code to export DataGrid to excel base on the html stream technology. But that one works only with worksheet cell. Is there any way to output Excel Chart based on the html stream?
I am tryign to create an excel spreadsheet/chart using office web components in asp. However I seem to have a registeration problem. I'm running office2003 and IIs is also running on my pc. When the following line exceutes an error "invalid string class is thrown" :
set objChartSpace = Server.CreateObject("OWC.Chart")
I have intalled owc again but still no luck. IS it a registeration problem ?
I have a site on which the visitor completes a form. When submitted, the form field details (email address, business, etc) are stored in an MS Access database.
I have to log-in to my server at the moment to see how many forms have been submitted.
Is there a way - I am sure there must be - of linking this MS Access database, that is, the number of forms submitted to it (which is not the same as counter 'hits', because people can visit the site without submitting the form), to an ASP/HTML page which displayes the figure in chart form month by month?
I am trying to display a chart in my asp page. The problem is that I need to connect to a Database and if you see the HTML code you can see the connection String (User and Password).
If I connect directly to the database from the chart control, I can see the connection String in the html-code.
If I use a data source control, I can also see the connection String.
¿ Is there a way to hide the connection String from the HTML code?
