Automatic Summation?

[cook.jonathan.m]

I've got OWC to draw a chart for me and it looks great until I get to
data with an x-axis of more than 40 data points. Then "excel" starts
to do some adding of my data and totally screws up my graph. My x-axis
= dates and y-axis = efficiency. OWC puts the dates in 7 day groupings
and adds the efficencies together! Bad bad! How can I make OWC
display the raw data with out auto formatting after 40 data points??

 

[cook.jonathan.m]

machEff.Axes[0].GroupingType =
ChartAxisGroupingEnum.chAxisGroupingNone;

chAxisGroupingNone is your friend... hmm, any way to make the labels
show every few dates and not show the axis label on every data point?

 

[Alvin Bruney]

Have a look at the tick label spacing object

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[cook.jonathan.m]

Awesome:
machEff.Axes[0].TickLabelSpacing = 15; // weeeeee

One more question. Is there anyway to edit the tick labels themselves?
I'm not sure how to access that collection (heh i'm sure its a
collection) ( I could do a bit of programming to check the dates
passed in the SetData category to get the correct ones I want to see.)
Instead of it showing the actual dates. I just want it to display
months. Now, I can't edit the data points themselves (date, efficency)
be/c that'll screw up the graph.

BTW, I just ordered your book about 2hrs ago. I hear good things about
it.

 

[Alvin Bruney]

You can use a numberformat on the datalabel collection object so that each
label (piece of text) on the chart surface will be customized. The owc
allows you to customize every point being rendered so there is a lot of
flexibility.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin