• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Secondary Axis

S

Shay A

Member
Hi,
In the file attached, I would like to have the secondary axis to start from the same zero as the primary vertical axis. How can it be achieved?

TY!
 

Attachments

  • Secondary Axis.xlsx
    13.7 KB · Views: 6
Open the file
Select the Chart
Right Click on the Right Axis, Format Axis
Set the Minimum Bounds to Zero

upload_2016-5-30_9-2-58.png

If you do this always check the other axis as sometimes Excel will adjust it to suit

You should note that Products 1 & 3 have negative increases and dont show up here once you set the minimum to zero
 
You must log in or register to reply here.
Back
Top