Enlarging x-axis scale in already "working" diagramm

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Enlarging x-axis scale in already "working" diagramm

  1. #1
    New Member
    Join Date
    Nov 2016
    Location
    Stockholm
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Enlarging x-axis scale in already "working" diagramm

     
    Hello!

    I have a diagramm in which the x-axis gets its scale from another sheet (=sheet3!$A$3:$A$74). In the diagramm that shows like weeknumber (18 19 20 and so on). Now I need to put in 6 more weeks and changed to =sheet3!$A$3:$A$80, but the diagramm will not extend the weeknumbers.

    I am not that familiar with diagrams in Excel, the rest of the workbook works fine with the diagramm.

    Is it possible I am totally missing something or is it not possible to do what I want from Excel?

    Best regards!

  2. #2
    New Member
    Join Date
    Nov 2016
    Location
    Stockholm
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Enlarging x-axis scale in already "working" diagramm

    Forgot to mention: the original diagram is made in Excel 2003. I converted it into 2016. If that is of any importance?

  3. #3
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,424
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Enlarging x-axis scale in already "working" diagramm

    What kind of chart is it? Did you extend the Y values as well? Are there other series in the chart?
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  4. #4
    New Member
    Join Date
    Nov 2016
    Location
    Stockholm
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Enlarging x-axis scale in already "working" diagramm

    Hello Jon,

    thanks for your reply. It is a diagram based on a whole workbook, different sorts of sheets/values, 2 y-axis, one x-axis.

    Thing is, I gave up yesterday and rebuilt the diagram itself from scratch with Excel 2016 (using the old one as a sort of reference) and suddenly, it worked as I wanted.
    I am not an expert, but I guess it was a konvertion-problem. from 2003 to 2016, the rest of the workbook was fine, except the diagram?

    Best regards,
    nova_sweet

  5. #5
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,424
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Enlarging x-axis scale in already "working" diagramm

      
    Yeah, this kind of problem occurs from time to time.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com