+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    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.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,641

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

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

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

    Quote Originally Posted by MrShorty View Post
    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

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

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

    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
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

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

    Quote Originally Posted by humdingaling View Post
    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

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

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

    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

  7. #7
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

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

    Quote Originally Posted by humdingaling View Post
    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?

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

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

    syntax for offset is
    OFFSET(reference, rows, cols, [height], [width])

    so just change where the count goes...put it as width instead of height like so
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  2. How can I make a line chart with all the data in column B and D and E?
    By sunheroj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2012, 02:35 PM
  3. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  4. Automatically Save updating Cell range Value Every Minute and make line chart
    By geneeus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2012, 07:50 AM
  5. Make Line chart not show (Contain Formula)
    By vietdieu in forum Excel General
    Replies: 1
    Last Post: 03-12-2012, 08:57 PM
  6. Replies: 4
    Last Post: 07-05-2006, 11:10 AM
  7. Change Line Column Chart to Line Area chart
    By recchie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2005, 11:40 AM
  8. How do I make a section of a chart line dotted?
    By odcltd in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-21-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1