Chart Help! I must be stupid!

OK, I have done 1000s of excel charts. Paste in the data, select the
data, insert chart and it works.
I am trying to do a simple line chart in RS and can't figure it out
after two hours. Maybe it is time to quir coding! My query returns the
following:
Product, Month1, Month2, Month3, Month4, Month5 (There Are Column
Names)
Proda 123 222 454 126 322 (this is the sales
data, row 1)
Prodb 333 526 447 631 262 (this is the sales
data, row 2)
Prodc 143 242 344 126 229 (this is the sales
data, row 3)
Prodd 153 123 467 116 122 (this is the sales
data, row 4)
I want a simple line chart with month1 thru month 5 at the bottom axis
and the
sales scale on the left axis. The series would be of course
proda,b,c,d. So I
want 4 lines on the chart from left to right representing month 1 thru
5 and the line would chart up and down based on the sales number.
In excel I paste in the table, hightlight it and insert a line chart
and it is 100% right. I'll email anyone the excel file who wants it.
What am I missing on this deal. I have looked every where and tried a
dozen combos. Thanks for your time!!
SheilaWhat kind of charts did you choose?
"George" <geomanks@.yahoo.com> wrote in message
news:e9dff8e4.0408171641.71a8b619@.posting.google.com...
> OK, I have done 1000s of excel charts. Paste in the data, select the
> data, insert chart and it works.
> I am trying to do a simple line chart in RS and can't figure it out
> after two hours. Maybe it is time to quir coding! My query returns the
> following:
> Product, Month1, Month2, Month3, Month4, Month5 (There Are Column
> Names)
> Proda 123 222 454 126 322 (this is the sales
> data, row 1)
> Prodb 333 526 447 631 262 (this is the sales
> data, row 2)
> Prodc 143 242 344 126 229 (this is the sales
> data, row 3)
> Prodd 153 123 467 116 122 (this is the sales
> data, row 4)
> I want a simple line chart with month1 thru month 5 at the bottom axis
> and the
> sales scale on the left axis. The series would be of course
> proda,b,c,d. So I
> want 4 lines on the chart from left to right representing month 1 thru
> 5 and the line would chart up and down based on the sales number.
> In excel I paste in the table, hightlight it and insert a line chart
> and it is 100% right. I'll email anyone the excel file who wants it.
> What am I missing on this deal. I have looked every where and tried a
> dozen combos. Thanks for your time!!
> Sheila