Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yoggi123
Starting Member
29 Posts |
 Posted - 2004-12-21 : 10:20:45
|
| Hey,I am trying to create a simple line chart, but I am having some trouble with the series values. I need to have my 'Year' series field only connect to one of my two data fields, but I am not sure how to do this, right now it connets to two of them and it gets real messy.Any suggestions?Thanks |
|
|
jhermiz
3564 Posts |
Posted - 2004-12-21 : 16:19:41
|
| provide more details please :). |
 |
|
|
yoggi123
Starting Member
29 Posts |
Posted - 2004-12-22 : 07:38:07
|
| Well, this is what is happening.I am getting my data from a stored procedure, and for this particular chart am need to use 4 different data fields, 'AverageFillRate', 'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond to the averagefillrate, so for example, between 2004 and 2006 I will have 3 fill rates, but the averagefillratetarget is constant among all years.This is the way the legend appears now:----- 2004 Average Fill Rate----- 2004 Average Fill Rate Target----- 2005 Average Fill Rate----- 2005 Average Fill Rate Target----- 2006 Average Fill Rate----- 2006 Average Fill Rate TargetI need it to be:----- Average Fill Rate Target----- 2004 Average Fill Rate----- 2005 Average Fill Rate----- 2006 Average Fill Rate...... etcSince the target is constant among all years, it does not need to correspond to any year field, and should be a straight line across the chart. Then I should have another three different lines on the chart corresponding to the years selected. But I have 6 lines, because I am getting a target line for each year as well, this is a mess.Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields dropped into the data field area, 'Months' dropped into the category field area and 'Years' dropped into the series field area of the chart.Any suggestions, and does this help any?Thanks |
|
|
|
yoggi123
Starting Member
29 Posts |
Posted - 2005-01-04 : 13:48:05
|
| Hey,Its the new year now, so I am wondering if anyone would have some new ideas for the trouble I am having?Thanks |
|
|
|
|
|
|
|
|
Charting Trouble