View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart line colors

Get out your version of Excel, make a chart like the one your code will
produce, then record a VBA macro while you change the series formats
manually. Then all that's left is to translate the VBA into VB.Net.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Pieter" wrote in message
...
Hi

I create a few charts in code from VB.NET using the excel interops, office
2003. In my software I need to be able to set the color of the lines i.e.
the color of each series on the chart. There may be up to 9 series per
chart. How do I asign a color to the series lines on the chart?

Thanks
Pieter