Trouble charting when I have to hide colums between date and data

I must have done something. If I try to create a columnar chart where I must hide columns between x-axis and y-axis data my resulting chart shows the order of columns reversed. i.e.if I have five data points data one shows up on the chart as the fifth column and data 5 shows up as the first colums and no data at all is plotted for points 2 through 4.
I had been charting okay but then this happened andI don't know how to correct it.
I will appreciate your help
cranlou

Please mark this thread as Solved