Skip to Content

Two y-axes for the same chart in SAP Analytics Cloud(without using bar and line combination)

Hi All,

I have been trying to plot total spend percentage spend on the same chart, as my spend value is in millions and % values is below 100 my graph does not look good. I do not want to go for Bar and line combination as line graph tends to mislead. Is there any other way in SAP to plot data with two different Y-Axis(at least anyway to remove the line joining the data points).

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 20, 2019 at 04:18 AM

    Yes this is how you can do that

    • Open a story with Combination Column & Line chart in it
    • Set one measure in Column Axis, one measure in Line Axis and one dimension in Dimensions
    • Untick Y Axes Overlap, find some positive values are displayed under horizontal axis

    https://drive.google.com/file/d/1ieRYvyQZvH_fvtpKDEOk_BnpPfsZlbYn/view?usp=sharing

    -Ashutosh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ashutosh,

      My query was regarding use of dual axis for bar/column graph. Right now we are using combination of bar/line graph with dual axis. But we don't want two show bar and line combination. Instead we want to use Bar and Market combination ( since the line graph indicates trend and we don't intend to display any trend among the different dimension values).

      There are two things which can fulfill my requirement

      1. Combination of Bar and Marker chart

      2. Cluster/group bar graph with dual axis.

      Is any of the two possible in SAC?

      Thanks in Advance>

  • Posted on Jan 08, 2020 at 07:37 AM

    Hi Pratik,

    Combination of bar and marker is possible, if you want both on the same axis. Refer attached.

    A bar/column with dual axis is not available as standard chart. You may choose to use R visualization if that fits your usecase.

    -Ashutosh


    untitled.png (132.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.