Displaying Average Not Sum For Values and Grouping

T

Tim McGue

I am creating an OWC 11.0 chart. The series is coming up as a SUM of the values. I want it to be an AVERAGE. I also want to group the timescale axis on hours and days. How can I do these things programatically

Thank You
Tim McGue
 
T

Thao Moua [ms]

Use this cod

set c=Chartspace.constant
Chartspace.charts(0).axes(c.chCategoryAxis).GroupingTotalFunction =c.chfunctionav
Chartspace.charts(0).axes(c.chCategoryAxis).GroupingUnitType = c.chAxisUnitDay

Chartspace does not support grouping by Hours. We only support Day, Month, Quarter, Week, and Year.

Thao Mou
OWC Webchart Suppor

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.ht

----- Tim McGue wrote: ----

I am creating an OWC 11.0 chart. The series is coming up as a SUM of the values. I want it to be an AVERAGE. I also want to group the timescale axis on hours and days. How can I do these things programatically

Thank You
Tim McGue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting default filter setting 0
OWC chart with date problem!!! 1
Avoiding cells being included in a chart 4
Finding the weighted average of text that have been given values 1
Multi Axis Pivot Chart 12
Average bar charts with individual data points 2
Excel 2007 charts: want to avoid zero values 1
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Top