• 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

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