View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
SrikanthAdimulam SrikanthAdimulam is offline
external usenet poster
 
Posts: 2
Default Vary Colors By Point

Hi Barb
Yeah I could make every line in the graph as a series and assign the color
index...It's a cool idea..

This serves my purpose...But I really think one should have a option of vary
by points for a series on a chart when there are more than one series on the
chart...

Anyways Thanx very much...

"Barb Reinhardt" wrote:

If you want to vary the colors by some known parameters, I've done it by
creating a series for each of the colors and only displaying the ponits that
are Yellow in one series, green in another. If I want the points connected,
I still plot the original series with connectors.
--
HTH,
Barb Reinhardt



"SrikanthAdimulam" wrote:

I am accessing excel through .NET C#..

I have two data series in a chart(XYScatterLines)..And I want to vary color
by point
of one series ...Infact I am not able to do that directly in excel manually...

Please help me out....

I even Tried following code..

grp = (ChartGroup)newChartObject.Chart.ChartGroups(1);
grp.VaryByCategories = true;