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"
May I want to know ASP or Javascript can generate a chart (pie chart) ?
or other method can do that?
I had downloaded your bar chart. Is it possible to read the values from the database?? If possible, how??
View Replies View RelatedIneed to create a something like a horizontal bar chart connected to a db. this is all very new for me, Can some one please suggest something....
View Replies View RelatedI'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?
Code:
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.
how I can do this pulling from a Microsoft Access database?
View Replies View Relatedwhat 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?
View Replies View RelatedI'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 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
Can someone provide me sample codes to plot line chart.
View Replies View RelatedI 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.
View Replies View RelatedI 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.
View Replies View RelatedCan anyone reccommend a decent chart/graph component to use with asp 3 (Not .net)
View Replies View RelatedAnyone 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.
View Replies View Relatedany 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.
View Replies View RelatedI 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.
View Replies View RelatedWe 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?
how can i create PERT/CPM chart in asp or any other technology. i want some code or referebce to create PERT/CPM chart.
View Replies View RelatedI want to know if there is a way to get a chart on some excel worksheet and stream it as a binary png or jpg picture to an asp page.
View Replies View RelatedI 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 need to generate a graph depending on the values in the database. Is there any free software related to this?
I tried some but in most of them we need to install the activex component. I am looking for software without any involvement of activex component.
recommend me a few alternatives for the Dundas Chart Software? What software can be used to build dynamic charts on my site?
View Replies View Relateda free line chart control for download?
View Replies View Relatedits possibles to do chart graphics from vakues in yours table with asp?
View Replies View RelatedI 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?