Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

C# and Excel Charts

Status
Not open for further replies.
jcmercure

jcmercure

Programmer
Oct 22, 2003
20
US
I am working on a C# development project where I need to update existing Charts in an Excel spreadsheet.

After some work I figured out how to get to the charts, but I am having trouble updating the SeriesCollection associate with the chart.

Based on the data that has been programmatically inserted into the spreadsheet, number of charted series my increase or decrease.

How does one go about removing a series from the SeriesCollection?

I am trying to use the Add method of the SeriesCollection to add/replace the existing series but I am having no luck. I am getting a Type mismatch error reported from OleAut.

Any ideas on the data types needed by the Add method and how they should be populated?

Thanks in advance for the help

- John Mercure
 
Status
Not open for further replies.

Similar threads

xarzu
  • Question
How do I establish an open connection to an open web browser in C#?
Replies
0
Views
285
xarzu
xarzu
hoangluc19
  • Locked
  • Question
Load hour and minute to datagridview C#
Replies
0
Views
1K
hoangluc19
hoangluc19
hoangluc19
  • Locked
  • Question
Auto map time and room to datagridview C#
Replies
0
Views
1K
hoangluc19
hoangluc19
WomanPro
  • Locked
  • Question
Where do we put public functions in C# (modules don't exist) ?
Replies
3
Views
1K
docotor
docotor
xarzu
  • Locked
  • Question
What is the proper way to declare a Microsoft class to use in my code. The quick and dirty way I am doing it here, I know, is not correct
Replies
0
Views
1K
xarzu
xarzu

Part and Inventory Search

Sponsor

Back
Top