10 Replies Latest reply on Aug 20, 2018 6:48 AM by suman kumar

    Dual Axis Questions

    Melissa Edmiston

      All- I am trying to find the best way to use a dual axis graph (bar/line) and am hoping someone can help me with a couple questions.

       

      1. Since the axis are synchronized, is there a way to only display one, not both?

      2. In the attached workbook, I want the bar centered over the year, so the line is essentially in the middle of the bar graph. I think it would read better. I have played with the sizing of the bar marks card between fixed and manual. It's currently in fixed and I just set the width to 250 days, but it's not letting me adjust the alignment to center. If I change it to manual, it displays the way I want it, but i can't make the bars wider. Any suggestions?

       

      Thanks in advance for any suggestions!