Reduce the horizontal axis

[jasonjhc]

Hi

I have a graph on a sheet which changes regularly. It is a sprint chart for 15 days most of the time. However, if there is a bank holiday within a sprint then this is reduced to 14 days. And more recently I want to run a 2 week sprint so I want the axis to reduce to 10 without having to create a new graph (as I just copy the sheet and all of its data/graph)

If I amend the axis using the edit function it reduces the text of the axis to 10, but the line remains at 15! How do I dynamically get the axis to change?

[dilipandey]

Hi jason,

See the attached file where I have used defined names to take care of days range issue :-

forum 130705.xlsx

Press Ctrl + F3 to see the names and their logics

Regards,
DILIPandey
<click on below * if this helps>

[jasonjhc]

Thank you,

Would you be able to give a little more detail as to how you achieved this please?

[dilipandey]

Hi jason,

Press ctrl + F3 to bring name manager window and there you can see the formulas. Offset and counta function is used there and you can see excel inbuilt help to explore these functions. Also you can watch some video tutorials over internet to see the working of these functions. Thanks.


Regards,
DILIPandey
<click on below * if this helps>