Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we add Z-axis (third vertical axis) to a chart in SSRS 2008 R2 Expand / Collapse
Author
Message
Posted Friday, September 28, 2012 2:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 9:15 PM
Points: 112, Visits: 319
I have searched the web and SSRS documentation but can't seem to find any information whether SSRS allows adding Z-axis (additional third axis other than x and y axis that comes in a chart) to a chart. Has anybody come across a solution to this? I am creating a report where I need to show two different series (along Y and Z axis) against the same category group (X axis). Please let me know.
I am attaching an example of a chart to show what I am referring to when I say z-axis.


  Post Attachments 
ChartExample.jpg (33 views, 83.04 KB)
Post #1366114
Posted Sunday, September 30, 2012 3:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 9:15 PM
Points: 112, Visits: 319
17 views but no replies .
Post #1366296
Posted Monday, October 1, 2012 7:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 5:09 AM
Points: 243, Visits: 2,699
For 2008R2 and above. You should be able to add your additional dataset as a secondary axis. I am not at machine that has SSRS, but I believe you just right click on the values set, go to properties, and then select secondary for the axis.

This blog may help get your started.
http://sqlservermsbiblog.blogspot.com/2010/12/secondary-axis-in-ssrs-chart.html
Post #1366539
Posted Monday, October 1, 2012 7:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:51 AM
Points: 316, Visits: 1,488
Your description of a z-axis isn't quite right. I think you mean to say dual Y-axis. A z-axis would result in a three-dimensional rendering, compared to dual y-axis which is still two-dimensional but allows for different data sets to be rendered on the same graph with different y-axis scales.

SSRS 2005 doesn't support dual y-axis natively -- a third-party tool like Dundas supposedly can.

SSRS 2008 should be able to define dual y-axis, however. Although I have not had the need to create a dual-scaled graph, here are a couple of links on how to do it:
http://technet.microsoft.com/en-us/library/dd207018(v=sql.105).aspx

http://sqlbg.wordpress.com/2010/03/18/creating-dual-y-axis-chart-in-ssrs-2008/

BUT, before deciding to render your data using dual-scaled graphs, you might want to read the following short article by Stephen Few, a data visualization expert. His article highlights the problems of using this type graph:
http://www.perceptualedge.com/articles/visual_business_intelligence/dual-scaled_axes.pdf


--Pete



Post #1366543
Posted Monday, October 1, 2012 1:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 9:15 PM
Points: 112, Visits: 319
Thank you both. Yes, my bad to think of the secondary axis as the z-axis. Adding secondary vertical axis worked just fine. Had seen this option while playing but did not think of it as I kept hunting adding 3rd axis.Thanks again,
Post #1366742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse