Hi,
I created a histogram bar chart based on steps with bin size 10,000. But I am unable to align my line markers (floors using dual axis) to the centre of each bar elements.
Any solutions? Thanks!
Chee Keet
Oct 21, 2018 9:23 PM
Hi, Cheek
Have you tried to use discrete instead of continuous for the bin as shown below?
I attached the workbook for your reference.
Hope this helps
ZZ
Oct 21, 2018 9:25 PM
Hi,
Try to synchronize the axis
Let us know if this help.
Mahfooj
Hi,
please check the below attachment if it is Correct or Helpful for you.
Thanks,
Amar D. Savale
Hi Zhouyi,
Your method works.
Thank you!
Chee Keet
Hi Mahfooj,
I think "Synchronize Axis" resets the range (i.e. set to the same range) of the primary axis (left-side) and secondary axis (right-side) .
Thank you for quick reply.
Chee Keet