Line chart too wide (52 weeks) How to make it the line chart automatically?

Hi, how to make a line chart automatic? I have 52 weeks as labels and right now im on week 1, and so the chart is way too wide. How to make the line chart automatically to add weeks, so if im on week one it would only show 1 week stats and then 2 weeks, 3 weeks, and not all 52 weeks.

Thanks, Bogdan.

Originally Posted by MrShorty

What axis type is the line chart using? I think, if you select a "date axis" (whatever constitutes the "format axis dialog" in 2016), I think it will do what you want without further modification.

If you must use a "category" or "text" axis, you will probably need to use "dynamic named ranges" to limit the categories to the "filled" range.

Thank you for reply. This is what I did.

Format Axis>Axis Options>Axis Type> checked date axis

and still don't work, I uploaded a picture of it, you can see it has 52 weeks but its way too much, I would like to see only what is live Forum help 2.png

Originally Posted by humdingaling

you require dynamic named range like mentioned
here is an example

http://www.techrepublic.com/blog/mic...arts-in-excel/

and another...think one is probably more clear on dynamic named range
http://peltiertech.com/Excel/Charts/...umnChart1.html

Ok thanks I will try this

Originally Posted by humdingaling

if you are having trouble with it then come back and explain which bit you dont understand
ideally attaching a sample workbook at the same time

we cannot work off pictures

https://www.youtube.com/watch?v=e33XhmmRXkE thanks to this video I got.

However, my codes are side ways and his codes are downside =OFFSET(Sheet1!$B$2,0,0,COUNT(Sheet1!$B$2:$K$2),1)

any idea how to make it side ways?