Is there any setting that could be used to set the zeros of both primary and seconday axis set in the same horizon?
Thanks!
Is there any setting that could be used to set the zeros of both primary and seconday axis set in the same horizon?
Thanks!
Hi Ceciwong,
Welcome to the forum.
I guess there is an option of starting horizontal / vertical axis... as "horizontal axis crosses" and "vertical axis crosses" where you can set them to start from zero. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
thank you for your answer, but i mean to set the zeros of the two vertical axis (the left and the right one) to be on the same line so that it could be easier to compare the positive and negative figures. is it possible?
Thanks
Could you share a sample image of the chart that you are looking for ?
Regards,
DILIPandey
<click on below 'star' if this helps>
sample chart.jpg
from the file, you could see the zero in the left axis is lower than that in the right axis. could there be any way to set them on the same line? thanks
See this article
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html
Hi Ceciwong,
I tried that and it worked.. see the attached if this is what you were looking for. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
@DILIPandey, take a closer look at the zero position of both Y axes, they are not aligned exactly.
The attached contains your original chart and I have coloured the primary and secondary axes so you can see the gap more clearly.
The second chart uses the suggested algorithm to correctly align the zeros.
thanks Andy.. I know you are chart Guru
regards,
DILIPandey
<click on below 'star' if this helps>
thank you very much. but i want both zero lines are coincided so that comparing the two charts' positive and negative values will be much more easier. but once again thank you very much.
did you check my example file?
Dear Andy, thank you very much. which macro should i run? do i need to run all 4 of them? when to run it? should i stay in the datafile or the chart to run the macro? thanks a lot.
Did you read the article?
"The following code includes four small procedures that invoke a larger one, depending which of the four relevant axis parameters you will allow to vary to make it work."
Select the chart to be affected and run 1 or all, your choice.
thanks a lot. can i copy your marco into my excel file?
It's actually Jon Peltier's code but yes it is available for public use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks