I have a combo chart that is showing stacked bar data by month and then overlays two line graphs.  All seems to be working just fine, except that I've been asked to list columns for months that don't have any data.  E.g. show all months January-December even if only March, April, May, and July have data so far. 

I've tried in vain to get this to work.  I managed to move the bars and add empty column spaces to the chart (using range -3 to 9) and I've managed to append the trailing month labels using C# and "scale.Labels.Add()" where scale is an  NScaleConfigurator object.  But I can't get labels into the preceding or intervening spaces where there is nothing reported (i.e., January, February, June).  Is there any way to do this (presumably in C#).  It seems that, once the chart is rendered, it is not possible to alter the label positions relative to the rendered data.

I'm working with a SharePoint 2007 list.  I'm reporting on defects and their status and I have already sorted the list by project as a view .  I'm using 3 fields from the list to build my chart:  Status values (reported as Open or Closed on the chart) as two lines on the graph, Severity values which I'm reporting on as a stacked bar, and one category of Month (sorted ascending).

Months are from a DateTime field (Date_Discovered).

The Status entries can be any of the following (entries [] on the right are how I'm treating them as Open/Closed status in my current charts - also ignore the quotes):

"Assigned"                       [Open]

"Closed-Duplicate"            [Ignore]

"Closed-Rejected"             [Ignore]

"Monitor"                          [Open]

"Resolved"                        [Closed]

"Rework"                          [Open]

"Submitted"                      [Open]

"Tested-Verified"               [Closed]

The Severity listings include the number and can be any of the following (ignore the quotes):

"1-Critical"

"2-Very Important"

"2.5-Pretty Important"

"3-Important"

"4-Inconvenient"

"5-Minor"

"TBD"

Date_Discovered is a single DateTime selection: e.g., 8/1/2013

As I'm grouping some of the severities together (i.e. 1&2 and 4&5), I have two status values (value 0 and value 1) and five severity values (value 2-6).  I'm using the following formulas.  I set the display for values 0 and 1 to be "line' and values 2-6 as "bar" and "stacked"

      The formula that I used for "Closed" is:

      =SUM(LIKE(Fields!Status, "Resolved")) + SUM(LIKE(Fields!Status, "Tested-Verified"))

      For "Open" I use:

      =SUM(LIKE(Fields!Status, "Assigned")) + SUM(LIKE(Fields!Status, "Monitor")) + SUM(LIKE(Fields!Status, "Submitted"))

      For the Severity fields I used a variant of the above i.e.:

      =SUM(LIKE(Fields!Severity, "1-Critical")) + SUM(LIKE(Fields!Status, "2-Very Important"))

      I repeat this for the other four severity possibilities.

For Category 0 I'm using

Group By:

 =MONTH(FORMAT(Fields!Date_Discovered, "s")

Label:

 =FORMAT(Fields!Date_Discovered, "MMMM")

Sort:

 =MONTH(FORMAT(Fields!Date_Discovered, "s")

  - Set to Ascending

I'm making separate versions of the chart for each project and some start on different months than January and some have no records for certain months as mentioned in my first post. I've been asked to provide an empty labeled column for months that don't have any records.

I've tried attaching a sample of what I've got so far (this one is linear months with data for each moth to-date and doesn't have any missing months).

Thomas

Attachments

Nevron Chart Example.bmp (529 views, 560.00 KB)