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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-10-30 : 05:59:29
|
| I have a chart with 2 category fields dropped into the x axis (Year and Time). In the layout view below the x axis of chart is:|______________ Group 1_____________________| on left and|______________ Group 2_____________________| on right.Similar to charts on: http://msdn.microsoft.com/en-us/library/aa964128.aspxThis is how I need to display, i.e. Year 1 data to leftand Year 2 data to right both sharing same Y axis.But when I preview the data Group 1 (2007) is on one chartand Group 2 (2008) is on a seperate chart.Anyone know what I've done wrong? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-30 : 14:41:53
|
| see thishttp://msdn.microsoft.com/en-us/library/aa964128.aspx |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-31 : 05:48:59
|
| That is the same link I posted in question. I've checked that page already and I cannot fix my problem. In layout view and in the little image inside chart properties - everything is as it looks on the microsoft page i.e. 2 groups, 1 chart.But when I preview it - the groups are spread over 2 charts.Could you expand on your answer please? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-31 : 06:42:31
|
| To clarify:The first chart (figure 1A) in webpage is my desired result. In this page the grouping is month eg. July and August alongside each other. In my chart I need the 2 years alongside. I stretched chart in-case it just needed room, and I also tried different chart types but I still get same problem. It looks right in layout but not when I run it.Time - is hours - I tried different formats but same result.The Year Group is a string value e.g '0708w1' and '0607w1' because it covers one week in an academic year. The chart is comparing a week's results for one year against another. The day value is in series - so there are five lines in chart for week days, with time 9am to 5pm along x axis. And my aim is to show both "Years" alongside each other. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-10 : 04:58:27
|
| Got solution on another forum. I had chart inside a list. Took out of list and it worked as desired. |
|
|
|
|
|
|
[Solved] 2 category groups in same chart