I'm using Dundas Chart Profession within my VB program to generate a chart based on my data. Right now I have my charts opening fine but I am unsure how to add the functionality to let the user choose to print (and export) the chart once the program is running.
View 1 RepliesIs it possible to export all charts created in the tabpages to MS word? If yes, how to do this? TIA..
View 2 RepliesI have an Excel 2007 workbook chock full o' VBA macros that do various things, including one that jumps from chart to chart making PDFs of each using PDFCreator, based on some code I borrowed from Ken Puls (url...).However recently I and some users of the workbook started having problems where the PDFs would be created with either gray image artifacts over the charts,or the whole chart image would have a double of itself skewed slightly. It just happens the problems started after we did a global upgrade to Office 2007, though I had had 2007 installed on my computer for a while and tested and used the workbook extensively without issue up until then. Here is the part of the code that automates the printing:
Sub PDF_print_all()
'Author : Ken Puls (www.excelguru.ca)
'Macro Purpose: Print to PDF file using PDFCreator[code]...
The problem is not consistent either... sometimes it will print to PDF with an oddly shaped block of gray, and sometimes it will only have the whole chart image doubled. The only consistency I could find is that sometimes if an object is selected in a chart beforehand (a text box, chart line, axis numbers, etc) the gray artifact will partly mimic the shape of whatever object had been selected.I wish I could include example images to show exactly what's happening.I know it's not a problem inherent to PDFCreator because if I manually print to it in Excel, the PDF image looks perfect. It's only when I use the automated method that the problem occurs, so I thought maybe it was the code.
I want to start off and say, I figured out how to take the content of a datagrid and put it in a print document. However, the length of the page changes based on the amount of rows in the grid. It never goes to a second page. How can I get this to go to a new page after 'x' amount of rows? If this is not the best way to achieve this, then could anybody point me in the direction of a sample code that can export the content of a datagrid (not datagridview) to a crystal report?
View 2 RepliesI am developing an application using VS 2008/MySql and I am trying to export the crystal report on runtime using my own code. I get an error saying:
Quote:Invalid export DLL or export format.
My code is:[CODE].....
I have been able to export data from a query to the xlsx file..howerver those fields which are currency in my sql server 2005 table are currency are showing up in the spreadsheet as text. The column mappings are correct when I look at it in connection manager.
Also Is there also a way to create a new worksheet each time the export is run or does the file have to be already named?
How can we add charts in VB.Net?
View 1 Repliessetting up a Bar chart and a Pie chart... The Barchart repsent how many people have that and the piechart is how much of what that person has bought.. i need to be able to change that?
View 2 RepliesHow to create org charts in vb.net?
View 6 Repliescurrently i m workin on Ms CHarts wid VB.NET nd create a chart sucessfully bt nw i wnt to click on that particular bar of that chart nd want to get that particular axis label of that bar ..
View 2 RepliesI am new to Visual 2010 and cannot seem to find any information about using Charts.I have an array, call it PressureOutputs(1000), which I wish to plot against a second array,e(1000).Can anyone please explain how I would add these two arrays to create a series on an x-y scatter graph (which is already present on the Windows Form Application), or point me to a source of information about how to do this?
View 2 RepliesI'm trying to get my head around excel charts. I've poured over these posts for the last couple of days now and i'm coming up dry. I've got a xl file thats got some data in the first 2 columns. I want to put the data in an XY scatter plot. Column A is the x coordinates and b is the Y.[code]...
View 6 RepliesUnder VB2 I could create a form with many charts (One form had 12 graphs). You could define the chart once and cut and paste it the required number of times on the form. Each chart had an index and the code used the index to create and update the desired chart with the appropriate x,y data. Is it possible to do this in VB2010?
View 5 RepliesMy project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 RepliesI am writing an ASP.Net VB2005 application, and I want to give my users the ability to create custom reports and charts on the fly, based on parameters defined in a wizard control. The data source is SQL 2008. This is also on my own dime, so I am looking for something that will not require a second mortgage.
View 2 RepliesHow to create Charts in vb.net. Is it possible to have a chart like this without any additional components
View 1 RepliesI have a MVC application, which creates a Chart in the business logic like this:
StatisticsModel.Chart.Width = 150
StatisticsModel.Chart.Height = 300
StatisticsModel.Chart.Attributes.Add("align", "left")
StatisticsModel.Chart.Titles.Add("Statistics for: " + StatisticsModel.ProductNumbers)
StatisticsModel.Chart.ChartAreas.Add(New ChartArea)
[Code]...
i am working on a vb.net windows application. i want to incorporate the dynamic graphs and charts in the application.
View 1 Repliesi am trying to use an arraylist to build a graph using fusionfree however i cant get it to work, it keeps showing the same item from the array list
[code]...
I have a form with two seperate charts placed on top of each other.I am trying to set up a toggle button that works in sequence i.e. loads second graph over first on click. When clicked the second time it loads the first one and so on.I realise i can do this by making one visible then making it not visible but i am having troubles with the circular click requirement.
View 3 RepliesIs there a way to conditionally format an Excel Chart? For example I have a bar graph. Currently I have the bars a purple color. I would like to turn a certain bar red if it meets certain criteria. Is there anyway to do this?
View 1 Repliesi want to create excel charts in vb.net with data fetched from my database server in which records are selected at run time through vb.net form.
View 5 RepliesI would like to create several pie charts at form load. I have a database and I'm able to populate the pie chart dynamically but what I want to know is that is it possible for the system to create multiple pie charts? The pie chart represents the amount of free and used disk space.. obviously a server has multiple drives. I would like each pie chart to represent each drive.. but I don't want to drag and drop a chart control each time.
[Code]...
Can i create a connection which will give the next registered user a user ID (a number) from the .csv?
II tried something with Sum and +1 every time an "add" button is clicked, so it would count the number of registered users but when i clear the .csv file i will have a number that ain't connected with the amount of users.
if i Ex. have twenty people registered in my .cvs file the next one will show the number 21 in a label in the "add form". Excel have the numbers from the 1 to infinity in the side if i could call the next empty line number into a label or something like that the user ID will follow the numbers of registered users.[code]....
I'm trying to create multiple Excel charts, in one work sheet using VB.net.This is the code:
Code:
'creating the chart
Dim chartPage As Excel.Chart
Dim xlPump1Charts As Excel.ChartObjects
[code]....
how to create data charts in Access / VB ?
View 2 RepliesProbably a silly question but is it possible in Excel or VB to drag a charts point(s) ?I had a quick look at the object "Points"(part of Series Collection object) methods and saw there was a "Select" function.
View 4 RepliesI am creating a data analysis program (using Visual Studio 2010) having several functions. One of the functions is to create graphs (scatter plots) of my data. Now occasionally, I may collect a data point that appears good when I take it, but when I plot it on my graph, I find that it's bad data and needs to be deleted.
My problem is that I would like to have a button called, say, "Delete Points". I hit that button and then choose the point directly from the scatter plot. The data source for the plot is then updated removing the offending point. I would then also have a button called "Restore Points" to bring back deleted points.
I have been thinking of doing this in Excel, but only because I don't have much experience with any other plotting program. Using the Excel approach will have its shortcomings, like needing to push the "Delete Points" button on a GUI separate from the Excel window (and thus needing to activate the Excel window).
I've looked around, I can't find much documentation on Line Graphs using the MS Chart Addon for VB2008.
Whenever I add the "chart" control (which seems to be the only new one in the property browser) a Bar Graph appears. I'd like to create a line graph rather than a bar graph, I don't see an option to change the kind of graph it displays. I'm sure I'm missing something simple, since I've seen people able to create their line graphs almost immediately after installing the control.
I m making a chart using MS Charts. Now the chart has mark points from where i want to get the coordinates if user clicks on the mark points.
I want interactivity in the chart such that on clicking on the mark points i can retrive the cordinates (x-axis and y-axis) for the mark points.
For example for the graph:-
on clicking on the orange dots or blue dots i want to get the cordinates for that point,
for example the first blue point is (10/11/2011, 49)