Post reply

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

  • September 28, 2012 at 2:23 pm

    #282321

    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.

  • September 30, 2012 at 3:46 pm

    #1543766

    17 views but no replies :(.

  • October 1, 2012 at 7:00 am

    #1543962

    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

  • October 1, 2012 at 7:04 am

    #1543965

    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/[/url]

    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

  • October 1, 2012 at 1:34 pm

    #1544125

    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,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply