Simple Chart request - I am struggling to get this.

**shashidhargani** · 07-22-2009, 01:47 AM

Hi,

The Required chart format and Data are attached.

I am struggling to create this.
Please help.

Thanks,
Shashi

**Andy Pope** · 07-22-2009, 04:58 AM

You can use a pivot table/chart to produce this chart.

You will need to add 2 extra fields to your data for MonthName and Year.

Open is a calculated item, summing the Status items. This gives the same information as the Total column, which is not included in charts.

**shashidhargani** · 07-22-2009, 07:53 AM

Andy,

No...

The Line chart should show the number of items opened in a month. The one you have done is correct. But the vertical Bars are incorrect because- "In the Bar chart, the items opened in previous months should get carry forward to existing month if they are not closed". Please see my initial attachment.

Thanks,
Shashi

**Andy Pope** · 07-22-2009, 09:28 AM

You need to construct a formula that will count rows that have information of a given month.

My brain is fried at the moments as I can not construct one, given the information in your data. I will try later.