Graph Excel - Axis break

I have a excel graph (line graph) and a number of series data, One series is much larger then the rest thus makes the rest of the data series look straight lined, I need to put a axis break in the y-axis so a certain range on y-axis is hiddenany ideas anyone ...

percentages in bar graph-excel

this is an excel question, I want to display the percentages on the x axis of bar graph, but under format data series>data labels, the percentage check box is disabled for column and bar grahs. How do i display the percentages, if i give the data in number format ...

Using Excel Automation

How can I draw a Graph Excel 2D with a table of points (X,Y) in Vc++.For exemple, I have a list of 100 points (X,Y) and I want to make a Graph Excel 2D with them. How can I do ?Have someone source example of using Excel automation ? ...

create an "Excel graphic" with Visual C++

How can I draw a Graph Excel 2D with a table of points (X,Y) in Vc++.For exemple, I have a list of 100 points (X,Y) and I want to make a Graph Excel 2D with them. How can I do ? ...

Graph Exel with Vc++

How can I draw a Graph Excel 2D with a table of points (X,Y) in Vc++.For exemple, I have a list of 100 points (X,Y) and I want to make a Graph Excel 2D with them. How can I do ? ...

Graph Exel with Vc++

How can I draw a Graph Excel 2D with a table of points (X,Y) in Vc++.For exemple, I have a list of 100 points (X,Y) and I want to make a Graph Excel 2D with them. How can I do ? ...

VBA Problem

I am doing excel vba progrmming where in I have written prog to create a graph using worksheet data.In the graph on the x-axis it shows empno and y axis shows salary.the data in the worksheet is as follows :Empno Salary101 1000102 1100103 2000While drawing the graph excel create the range on it's ow ...

how to plot different x axis values in the same graph of excel automation by MFC?

I have some difficulty in automatically plotting several curves in the same graph in excel by MFC.In MFC, I automate the chart plot by calling ChartWizard. If the data used to plot sharing the same x value, for example, they are listed as x, y1, y2..., it is easy to plot out these curves on the same ...

Excel Graph Help

HiNot sure if this is the right place (part of the forum) to ask this:Is it possible to have an EXCEL graph but with a slider bar along the bottom to scan through the x-axis data values - I have graphs with several thousand data points with share trading data and an associated EXCEL VB coding that t ...

How to display graph in chart using Excel

I want to use excel for displaying graph. I refer MSDN artical "Use MFC to Create a Microsoft Excel Chart (Q178783)". It almost satisfy my need. But it display the chart in same sheet in which values for drawing graph is. I want to display the graph in another chart. Simply stating in shee ...

Graph drawing without using Excel

I want to draw line graph without using MsExcel. I found many application on codeguru to plot the graph using Excel feature. But want to plot the line graph without using Excel. Can anybody help me out? ...

using VB2003 to accept excel file and convert it into a graph

everyone!! Does anyone know hoe to use Visual Basic 2003 to accept input from an excel file and convert it into graph? I really need to know this as I am doing a final year project and I have a deadline to meet.All your comments and help is MUCH appreciated.Tks!! ...

creating graph from perl using excel

can anyone give an example to create a graph from perl using excel.i am new in perl programming. ...

how to create a graph in Excel from Access?

the title says it all ppl! anyone knows how to create a graph IN Excel using the values IN Access? ...

Excel slow/crashing when I generate a graph using C#

I am using C# to make an app that will read an excel file, edit the data and then generate a graph for me using said data. The program works well, but when I open the graph in excel it is incredibly slow and sometimes crashes excel. I think the problem is in the code I wrote to generate the graph bu ...

generate excel graph from dynamic data

I need to generate a dynamic bar graph in excel.The code is in java and related technologies.On my site when a click a button 'generate graph for selected values' i should to get a bar graph in excel.Since the values selected can change and also the data associated with them,the graph should be gene ...

Urgent Help: Create a graph in excel every day directly with clearquest

Here is a condition, I want to write a VB script that automatically transfers the database of clearquest to the excel and creates a charts relating to that database in excel sheet. The job should be performed daily and should be automated. Suppose their is a record type Defect and the script should ...

graph does not export to excel

I want to export evrything in a page to excel, it's just the graph that does not export. I used ChartControl graph which I downloaded.protected void excel_Click(object sender, EventArgs e){excel.Visible = false;Response.ContentType = "application/ms-excel";Response.AddHeader("content- ...

graph does not export to excel

I want to export evrything in a page to excel, it's just the graph that does not export. I used ChartControl graph which I downloaded.protected void excel_Click(object sender, EventArgs e){excel.Visible = false;Response.ContentType = "application/ms-excel";Response.AddHeader("content- ...

Urgent! How to read excel data and show the ploted graph in a created dialog

I need to implement a simple user interface, that can read excel data and show the ploted graph on a dialog. Later in the stage I will try to implement writing to excel data as well. Please if anyone know any approach to my problems, please your suggestion is very greatful.Best regrads,David ...

Is there an easy way to create a graph using excel?

Is there an easy way to create a graph using excel? ...

How to automate Excel 2000 to generate graph within VC++

Can anybody share with with me how to automate Excel 2000 within VC++ to plot the graph after receiving data from user interface. Pls help me if u can, ...

Help!! How to automate Excel 2000 within VC++ to generate graph

I'm doing a project that requires me to plot graph using VC++Can anybody share with with me how to automate Excel 2000 within VC++ to plot the graph after receiving data from user interface. Pls help me if u can, ...

Excel to graph

I am developing a programming in which i invoke Excel to graph some values. It usually works but sometimes it doesn't and gives me an error such as "Couldn't start Excel and get an Application object". IS there any way to get rid of this case.thanks for any help available.HET SHAH ...

Problem in creating a data series to plot XYscatterlinesmooth graph in excel VB

I have started using VB from past 1week.I have a problem in hand. I want to plot a XYscatterlinesmooth graph inside the chart space in excel VB. The data for plotting the graph is to be read from the excel sheet1 which contains data in column B (B2:B10) and column C (C2:C10).I am getting error in my ...

Retrieve values from Excel graph

In Excel i want to retrieve the values from a graph with Visual Basic.Anyone knows how to do this? ...

embed an excel graph and worksheet in a form

I would like to embed an excel graph on a form. Moreover, if a "show data" button was pressed, the data of the excel graph can be shown in a datagrid. p.s. :The excel graph is generate at run time by OLE.I have read some books of visual basic 6.0, there is an OLE icon in the toolbox; howev ...

Excel Graph & ASP 3.0

i am creating various charts(graphs,line,pie etc.) in excel sheet on the basis of various values.i want to show that chart(graph) on asp page. i want to just display that charts on web using asp. if i change any value acc. to that the graph will chage, that updated graph should be seen in asp page. ...

Creating Graph in Vfp

How to create Graph in Visual Foxpro? I also want to change the graph at runtime by connecting the table, which changes automatically every 5 minutes. ...

Creating Graph in Vfp

How to create graph in Visual foxpro? I also want to connect a table to the graph, which changes automatically after 5 minutes. Graph also make change as soon as the table changes the value. ...

MS Excel Graph Help

I have a X Y scatter plot of data points. I would like to delete some of these points on the XY plot, while keeping some. The attached picture will demonstrate problem more clearly.Since, these datapoints in the spread sheets are spread. I can not delete it from the spreadsheet. I need to look at th ...

create hyperlink in excel using VFP 6.0

Does anyone know the code to add a hyperlink to an excel cell using Visual Foxpro 6.0.I can create a worksheet and select a cell, I just can't create a hyperlink from VFP6. ...

Using PHP to generate Excel spreadsheet with Graph

Has anyone ever done this before? What must I do to ensure that my reports, built in PHP, will export to an Excel spreadsheet with graphs built upon the recordset data?ThanxPhil ...

Ubuntu Excel graph axis problem

bar/column graphs in ms excel (using wine) dont display their axis labels, but they display fine in OOo spreadsheet, wth?http://img826.imageshack.us/img826/9528/screenshote.png ...

Creating an excel graph in a dialog window

I have an array of points (x,y) and I want to display an excel chart in a dialog.Any ideas how to do this?Dan B ...

presenting a graph from an excel file

i have an excel file with a chart already constructed in it. I wanted to display that chart on a visual basic form that i have created. looked at many forums, but none seem to describe how to extract a chart from excel to the form.spent hours just to find a solution, tried creating a chart with the ...

using VB2003 to accept excel file and convert it into a graph

thank you but I have this error now:'EndOfStream' is not a member of 'System.IO.StreamReader'.I got this error even though I imported the System.IO.StreamReadersorry.. ...

move graph from excel to word with macro

how do I do it? ...

Why doesn't my graph seem to show? Extracted Data from excel

Private Sub CreateChart()Dim time2, tp As StringTryDim sr2 As New StreamReader("D:\Temp\datalogger\" & date1.ToString & "\int_sma_" + date1.ToString + ".txt")Dim line7 = sr2.ReadLineDim tn = timeNow()Do While Not line7 Is Nothing 'loop until end of fileIf IsNume ...

Oracle Forms 4.5 & Excel & OLE2

HiI export data from Forms 4.5 to Excel (on a 'Feuil1') and I would like to generate a graph (on another sheet 'Graph1') but I have problems when I want to specify the data sources. I specified the type of the graph and the legend but I need help to succeed in specifying the data source with for exa ...

nmon analyzer Excel timeline out of order

Is anyone having an issue with all graph timelines? I take a nmon file that runs at 5 second intervals for an entire day. When I use the analyzer to convert to Excel all the graphs that have a timeline are all out of order. So starting on the left of the graph should be 00:00 moving in time to the r ...

In MS Office. Which is best for graphs. Excel or Access.

I have MS Office 2003 and 2007. I need to record my blood pressure and present it as a graph. What is the best way to do this? I cannot find anything in the Excel made simple book.Excel, Access, Power Point, Outlook Express, Publisher and Word. are available.Any suggestions welcomed.:DTa muchly in a ...

Report Studio report Run/Export to excel does not work properly

Jerome Basdevant said: Hello Friends,We have created a report with two graphs and a list a at the bottom. Each of the graphs occupy 50% of the report page.When we try to run the report in Excel format second graph always overlaps the first one making it only half of the graph is visible.We tried sev ...

Excel interchanging data with access

HeyI have excel book with many sheets I need to import from to create access tables, the book being an unchangeable form. Mostly. I was planning to create macro for importing the data shellwise. But how can I check that I'm getting it from the correct row (in case someone has inserted another row)? ...

Linking Excel to Access Database.

All, I have a few questions. I have a database and I have queries I run weekly on this database. I want to be able to link these queries to excel and refresh say once a week and be able to plot grahs with the values returned from the queries.How do I go about this.I want to be able to populate an ex ...

Excel, rowcount monitoring (ODBC, Import)...

I want to monitor the progress of a project rollout by watching the growth of rows in the Oracle database. What I would like to do is create an Excel spreadsheet that goes to the database, returns the date, a list of tables and their counts(). OK, this I can do...The bit that I can't seem to solve i ...

Exporting data into Excel

Hello, I'm new to this site and this is my first post.I got an assignment where I have to do a QuickSort on 100,000 numbers first and then combine QuickSort and BubbleSort so that the BubbleSort comes in for the last 1,000 numbers. The information is to be exported into Excel, where I have to make a ...

How do I make a graph or chart for my website?

I would like to know how to graph or chart certain data that will be shown on my website? The graph would be simular to what you can create using Excel, first I should ask is that possible? And if it is, how would I go about doing that? ...

PLotting a map/graph

Hi, hmm hav a query right here about how do i go about plotting a map/graph using c programming.i hav the x and y cordinates which are the variables, but do not know how to go about starting/writing the program.i heard one of the ways is to import the data using microsoft ExcelWould be grateful if a ...

generating excel chart in VBA

greetings..i'm suppose to make a programme that reads a notepad file generated by other programme interfacing with an device which tests components, and then generates a graph of it in Excel.. so far i've succeeded in reading from the notepad file and making a spreadsheet in excel, but not able to g ...