Can we add Z-axis (third vertical axis) to a chart in SSRS 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Can we add Z-axis (third vertical axis) to a...

Can we add Z-axis (third vertical axis) to a chart in SSRS 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

bdba

Posted Friday, September 28, 2012 2:23 PM

SSC-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 (27 views, 83.04 KB)

Post #1366114

bdba

Posted Sunday, September 30, 2012 3:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 9:15 PM
Points: 112, Visits: 319

17 views but no replies Sad

Post #1366296

Scott Murray-240410

Posted Monday, October 01, 2012 7:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 159, Visits: 2,204

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

peterzeke

Posted Monday, October 01, 2012 7:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 285, Visits: 1,200

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

bdba

Posted Monday, October 01, 2012 1:34 PM

SSC-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 »

Permissions