473,378 Members | 1,621 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,378 software developers and data experts.

two series in one graph excel using c#

5
Hi,
My code drawing a graph in excel sheet. There one colum for lower pressure and another one for upper pressure. Any howi can draw a series for one pressure but i am not able to draw two series one for lower and nother for upper in a single graph.
My code is here
Before this code i opened worksheet , imported the csv data and trying to plot it on the graph.

Excel.ChartObjects chartObjs = (Excel.ChartObjects)excelWorksheet.ChartObjects(Ty pe.Missing);
//Range drawing graph for b2 to b100 cells from stylesheet
range = excelWorksheet.get_Range("B2","B100");
// position of the chart
Excel.ChartObject chartObj = chartObjs.Add(200, 20, 300, 300);
Excel.Chart xlChart = chartObj.Chart;

xlChart.ChartType = Excel.XlChartType.xlXYScatterSmoothNoMarkers;
// ploting graph for the range and setting it
xlChart.SetSourceData(range, Type.Missing);

Colum B has lower pressure and colum c has upper pressure. i Want to draw both pressure graph in a one chart.
Any doughts if i cant explain it then ask me
Thks a lot,
Naish
Dec 5 '07 #1
0 1420

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

Similar topics

1
by: george_y | last post by:
I need some help to generate with a C++ programm a file in Excel format (or at least in a way that all the information in it can be read by Excel) containing a graph with the data I choose. As an...
6
by: David W. Fenton | last post by:
Is MS Graph really completely useless in Access 97? I uninstalled and re-installed to get the Office 97 version of MS Graph, but I see no way whatsoever to insert dynamic data into the chart....
1
by: Robin Tucker | last post by:
Hi, I am embedding various things into a Microsoft Word document. I want to embed and automate a chart control. I can embed an Excel.Chart.8 into my Word document manually (no problemo), but...
1
by: Mitch | last post by:
I am using Access to create an Excel spreadsheets with graphs related to rows on the sheet1 to the graph on sheet2. I am using the same data but different subsets of the data to make different...
6
by: Esha | last post by:
I was asked by my boss to create representation of data by Graphs in VB 6 application. I checked the features of VB6 Graph control as well as Excel graphs. They are not good enough. I tried to...
1
by: Herbert Chan | last post by:
Hello, I'm subscribing to funds on HSBC, and the fund prices can be found here: http://www.tools.hsbc.com.hk/search/mpf?id=hk+mpf+fundsearch&lang=en&init=true At the moment, I'm copying each...
3
by: Jawad Rehman | last post by:
Hello everybody..... I have an excel file which is resided on server,there is some data on the cells .Now i want to generate dynamic graph on the basis of the data present in the excel file ...
3
by: Jawad Rehman | last post by:
Hello everybody..... I have an excel file which is resided on server,there is some data on the cells .Now i want to generate dynamic graph on the basis of the data present in the excel file ...
4
by: keirnus | last post by:
Hello, I've been coding in Access VBA to create an Excel Graph and it was good. Until I got this error: Please check the code below: Private Sub TestGraph3()
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: 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...

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.