SSRS Line Chart

[nandan619]

Hi,

Hi,

I am having a report which contains a line chart. I have tried different alternatives, but i could not get it solved.

There are many line in the charts representing Baseline,Actaul Weight, Gas Usage and so on.

I want previous year records over the current year records for the date range i select.

I have the records for the current year Date range i select and it is displayed as a line graph. But i also have previous year data for same date range.But, i want it to be displayed along with current year data, but on a different line graph.

Please let me know if i need to provide some more information.

Line Chart with

Drop Category Fields : WeekNumber

Drop Data Fields : Different Calculated sum columns.


Please help me if anyone can.

Thanks.

 

[Crowley16]

do you mean on the same chart, but with a different line, or do you mean on a completely new chart?

option 1, just add the previous years data as a new data series...

option 2, you'll need to create an entirely new chart...

--------------------
Procrastinate Now!

 

[nandan619]

I added a new data series to the same chart but the lines are grouped based on weeknumber.If i do grouping on years,months or day the lines won't be one over the another.
I want both current year and previous year data lines one below the other.

 

[Crowley16]

I think in this case, you want 2 seperate charts, one for current and one for previous.

it doesn't make sense that you have one line above another line, even if the value below is larger all on the same chart, you'd need some sort of quantum axis for that...

--------------------
Procrastinate Now!

 

[SgtJarrow]

You might want to look at the second axis that is available. You can add both data series and put each on its own axis. You would set the axis of each series to be the same range, but they would be "graphed" separately on the same graph.

Of course, you will have to test that to see....

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer