Thanks! I'm searching for this one.... By using your method, when actual date and duration has blank values, and after deleting secondary horizontal value axis in chart, it is displaying from 0/1/00. Any solution?
@ExcelNaNa3 жыл бұрын
You might not set Minimum Bound in Primary Axis Option. If you don't know how to do, please check this vdo: kzbin.info/www/bejne/rXKlgKafedh6mtk
@veerasegaranpl21123 жыл бұрын
@@ExcelNaNa I have linked with Pivot table and slicers, so Bound in Axis field is set to 'Auto'... Here if Secondary axis date is blank it is automatically taking 01-01-1900
@ExcelNaNa3 жыл бұрын
try to change Duration to be NA# in case of blank Actual Date H5: =IF(OR(ISBLANK(F5),ISBLANK(G5)),NA(),G5-F5+1)
@ธีรพงษ์บุญฉลวย4 жыл бұрын
Excel 2007 จัดแกนที่ 2 ตรงไหนครับ
@ExcelNaNa4 жыл бұрын
Click ขวา เลือก Format จะมีให้เลือก Primary / Secondary ครับ
@hamiltonstolpen3385 жыл бұрын
do you have a template file you can email for this?
@ExcelNaNa5 жыл бұрын
You can get the sample file from this link www.dropbox.com/s/dmfj9guyoxkuqjp/xnGanttChart-PlanActual.xlsx?dl=0