共用方式為

Creating a Second Y-Axis on an Analytic Chart

  • 發行項

Did you know you can get a 2nd y-axis on a chart? This can create what some people call a mixed-series chart, with a combination of bars and lines.

If you add 2 measures to a Bar Chart, one of which has "normal" numeric formatting, and one which is formatted as a percentage, PerformancePoint will draw the % series on the right axis.

For example, here's a simple chart with one bar series.

clip_image002

Add a 2nd measure to the query, and if it's a percentage, PerformancePoint will automatically add it to the right axis. That's it.

clip_image004

Note: Be sure to add your percentage measure as the first measure in the Series, that way the lines will draw on top of the bars. If the percentage measure is second, the lines will draw behind and may be hard to see.

We don't have a way to manually control this yet, we are hoping to add that in a future version, but for now, you can create mixed bar/line charts as long as you're using percentages.

Greg Bernhardt

Senior Program Manager - PerformancePoint

Microsoft

gregbern@microsoft.com

Comments

  • Anonymous
    February 12, 2008
    Did you know you can get a 2nd y-axis on a chart? This can create what some people call a mixed-series

  • Anonymous
    March 05, 2008
    Thank you very much. This helps a lot. I just got back from PPS week training and instructor showed the screen shot, but had no idea how to do that... Thanks, Yuriy.

  • Anonymous
    March 30, 2008
    The comment has been removed

  • Anonymous
    March 31, 2008
    The comment has been removed

  • Anonymous
    March 31, 2008
    Thanks for help. Please advise how can I attach a screen chop here to help communicate? I just used the "Getting started tutorial" in Proclarity as my example. My scenario is as follows:

  1. Row: sales amount
  2. Column : Product category
  3. I want to add "% Gross Margin" (from Measurement) in to the "Row" as my 2nd data series....to be plotted in Y2 axis. But when I applied, the Row was replaced by my 2nd selected measurement (% margin), that means, I can never add another data series in row, and further specify it to be plotted using Y2 axis. Please advise where did I go wrong with my Proclarity 6.3 DT professional? Or, was it due to version difference? since I could not see the screen like Greg posted... Appreciated. Lance.

  • Anonymous
    April 01, 2008
    You need to control click to add % gross margin in addition to sales amount. Once you have both on the rows you can right click on % gross margin and move the series to the y-axis (in ProClarity at least). If you are still having trouble email me at alysonp@microsoft.com

  • Anonymous
    April 01, 2008
    Is it possible to do this with two dimensions instead of 2 measures? I am playing with my MDX query to try and get it to render the graph in the manner you have above but I cannot figure it out.  In my case, my values are dimensions (one is a % and one is a $).  Any ideas? Thank you!

  • Anonymous
    April 01, 2008
    Only works for measures. Sorry.

  • Anonymous
    April 02, 2008
    In case of the perspective view, does it support to differentiate the dimensions by colors of the data point? And further to display the 3rd measure by using the area size of the data point? (like bubble chart) Thanks for advice.

  • Anonymous
    July 05, 2008
    how to display all of them in Legend, when there is more than 30 series?

  • Anonymous
    September 30, 2008
    We had a need on how to add a second axis on an Analytic Chart and I found the following link. Very helpful...

  • Anonymous
    November 09, 2008
    i have requirement to have both in a single chart can we do like that in pps. Also how i can control the axis values if second axis we don't want to display. Thanks in advance

  • Anonymous
    January 08, 2009
    The comment has been removed

  • Anonymous
    January 09, 2009
    The comment has been removed

  • Anonymous
    March 25, 2009
    The comment has been removed

  • Anonymous
    November 03, 2010
    What about SharePoint 2010 with PPS. Is it possible to control th second Y-Axis manually. I would like one axis with sales quanitity and an additional with sales in local currency. Regards, Jonas

  • Anonymous
    November 17, 2010
    Is it possible that all the series are non Percentages?

  • Anonymous
    December 10, 2010
    A secondary axis is extremely important in the business world, and this solution does not provide a way to compare two measures (Qty On-hand, Units Sold) which is extremely important.  Or even better, average retail vs units sold.  If someone knows of a solution for this using an analytic chart, please post.

  • Anonymous
    May 13, 2011
    This there any way of making the right Y axis a numeric value other than percentage?

  • Anonymous
    March 14, 2013
    Is there any way of making Y axis as numeric value other than percentage?

  • Anonymous
    July 08, 2013
    The comment has been removed