473,695 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel Graphs

In the Excel it is not possible to graph more than 256 columns, is it possible to do call Excel library from C# and graph more than 256 points / columns or does the library has the same limitations?
Thanks
Peter

Nov 17 '05 #1
3 1365
Hi

This is Excel's limitation. It has only has 256 columns and excel chart is
based on excel table.
Our programming against Excel, is named Automation, that is to do the same
job as we do with UI.

So we can not use code to exceed the limitaiton.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 17 '05 #2
""Peter Huang" [MSFT]" <v-******@online.m icrosoft.com> wrote in message
news:LR******** *****@TK2MSFTNG XA02.phx.gbl...
Hi

This is Excel's limitation. It has only has 256 columns and excel chart is
based on excel table.
Our programming against Excel, is named Automation, that is to do the same
job as we do with UI.

So we can not use code to exceed the limitaiton.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.


Thank you
Nov 17 '05 #3
Hi

Welcomed!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3758
by: mscir | last post by:
I'm trying to find thorough documentation for creating graphs using serverside Excel from ASP. Any book recommendations? A well-documented COM wrapper would be nice if it allowed us to create may different types of graph, e.g. Wind Rose (for wind direction), thermometer, as well as standard pie, line, bar charts. I've found a few examples of charting code on websites and at MS, but none of them contain a thorough explanation, and our...
0
12412
by: Rach | last post by:
Hi, Does anyone know how to export charts/graphs from EXCEl into Powerpoint-Microsoft Charts though VBA code. I would like to import the underlying data with the chart as well. I know we can paste as an Excel object in power point which links the Excel file to the power point, but this increases the file size. Microsoft Power point has a feature called Microsoft charts that allows to create charts and graphs in
0
2111
by: David Caissie | last post by:
I am trying to automate a Vb.net chart using the excel COM object. The problem occurs when trying to run the code in different systems. It is working fine under one of my computers but once i move it to another one it fails giving me the error: Additional information: Unable to set the HasMajorGridlines property of the Axis class Here is a excerpt of the code being run.
4
9132
by: Peter | last post by:
Does anyone know a way to import excel data very fast? I have spreadsheet data that has to be processed, the spreadsheet has 256 columns and 20,000 rows of data. That's 5,120,000 cells. The cells can contain any type of data, but the data has to be coverted to Double arrays. Currently I read the data from the spreadsheed using OleDB and put the data into datagrid which is not too bad - takes maybe a minute, but when I move the data...
4
15010
by: Jiro Hidaka | last post by:
Hello, I would like to know of a fast way to export data source data into an Excel sheet. I found a way from C# Corner(Query Tool to Excel using C# and .NET) which is a neat little way of exporting dataset data to an excel using the Excel COM object. This works fine but the problem is its pretty darn slow when exporting large
2
296
by: edr | last post by:
Hi, I have a excel file templete, where i need to populate the raw data in the one of the sheet with the specific predefined format. based on the that data, a VBA program will fetch the data from sheet 1 and draw graphs in various other sheets. open the specific excel file from asp.net and then plot the data as per the pre requisite and generate graphs etc from this. I have had a look at some third party controls
1
4612
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 spreadsheets for different groups. The spreadsheet formats are the same for each of the different groups. So I am using a loop to requery the data for the different groups and create a new spreadsheet for each group. The three graphs on sheet 2...
1
1625
by: etangman | last post by:
Hello people. This is quick and easy I just can't figure out the correct syntax. Help appreciated. I'm attempting to create an Excel macro that replaces cell contents on one sheet with a connecting formula to update it from another sheet. I am currently using very uneffective code, and it has worked, but I have recently encountered a few problems. More effective code would be much easier to manage. Currently I am using the following: ...
2
1645
by: rene.marxis | last post by:
Hi I need some hints for the following problem. We have some customer that has one Excel file composed of about 20 sheets and he wants to convert this file to a small C# application. It's not that he does not want to use Excel at all, but there is data that has to be entered inside the first sheet and from this data all other sheets are calulated. Now he wants us to write some app, where his customers are able to
15
5244
by: OzNet | last post by:
I have a query (with calculated fields) in Access (2007) and the data changes depending on the dates and staff person selected. I need to produce a series of graphs based on the data in this query and it seems to me that Excel is far easier to create graphs than Access. When I use the Get External Data feature of Excel and the dialog box with the tables and queries appears, the query I need is not listed. Is this because the query has...
0
8631
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8572
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9115
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8984
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8847
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7661
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6491
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3003
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.