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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2009-10-19 : 09:12:45
|
| Hi all,I want to create a line chart in SSRS but I am having problems. I have a query that returns the following 2 columns: YearAdmitted, YearCount. My data looks like this:2006 152007 252008 202009 5I want a line chart with the years on the x axis at the bottom and the counts on the y axis. I then want just one line that charts all of this. But everything I try gives me a seperate colored line for each year / count. Is it possible to have just one line?Thanks,Bob |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-19 : 10:25:24
|
| When creating the graph, drag YearCount to the Data Field area at top and then YearAdmitted to the Category field at bottom. Sounds like you have Year as a Series.John |
 |
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2009-10-19 : 10:39:46
|
| John,Sorry, I had already dragged the 2 fields like you said to my chart. None of the counts are showing up on my chart. The years do siplay at the bottom though. I do not understand what you mean by "Year as a series"? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-19 : 11:18:25
|
| Dragged to the right side but I am probably wrong since they show up on the bottom.Check your email. I mocked up a simple copy.John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-19 : 11:23:11
|
| Search the code for "Pivotal_Data_Source" and replace with the name of a test data source name that you have. There are 5 occurences.John |
|
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2009-10-19 : 11:46:35
|
| John,That did it. Thanks a lot!! I really appreciate the help!! I used your code and then modified it to fit my requirements and it worked perfectly. You are the man!!Bob |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-19 : 11:53:19
|
| I just wish I was where you are... A lot closer to Key West than I am... Glad I could help!John |
|
|
|
|
|
|
Line chart help needed