Hi there,
I am trying to basically force Excel to be used as a Project Timeline.
I have had success so far with what I have needed adding Project statuses, Start, end date, % completed to be plotted as error bar etc.
However I am currently trying to add basically :
A secondary axis (with a scatter (points based on the planned start) and duration based on delta between Planned Start and End.
This duration I want to plot on each row as error axis (plus).
I am facing issues arranging them on the Vertical axis. I've tried creating the values for the axis manually.
As long as the rows are under 10 it works fine.
0.2, 1.2, 2.2 etc.
But when I reach 10.2 and above it goes all over the place.
Any ideas?
works.png
not_working.png
Attached is my file.
*one macro is used only to set the beginning/end of chart plotted easier instead of digging in.
Bookmarks