Crystal Reports Problem with Charts

Message

     Hi,

I have a problem with listing my data in X axis of Crystal Report chart. I have a simple chart and everything in my chart looks fine except the following.

I connect excel data to my chart and wherever in my excel sheet I have similar data crystal report cannot distinguish between the difference and I will see repeated words on X axis, I also try to change the words on x axis manualy but it change it for all other simmilar records. 

For example if I have three rows which have the same values in my following excel sheet (Jan,Jul and Oct 2011), Crystal Report pick only the first one and will repeat it for other two records. I would like to prevent that.

Month
Downtime
Occurrence

2009 Average
91
3

2010 Average
139
3

Oct-2010
182
2

Nov-2010
18
1

Dec-2010
65
3

Jan-2011
0
0

Feb-2011
50
1

Mar-2011
77
2

Apr-2011
45
2

May-2011
55
3

Jun-2011
228
3

Jul-2011
0
0

Aug-2011
30
1

Sep-2011
95
4

Oct-2011
0
0

I would appreciate your help.

Edited by pouyaslr - 13 Mar 2012 at 11:45pm