+ Reply to Thread
Results 1 to 11 of 11

Bar Chart shrinks when I add one more bar

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    6

    Bar Chart shrinks when I add one more bar

    I have a bar chart which shows my turnover for the last nine years, so I have two columns of data 'Year' and 'Turnover'. The bar chart is perfect with different coloured columns for each year with a coloured legend to the right showing what year is represented by each colour. But when I add a tenth year, the left half of the graph becomes blank and all ten years are squashed into the right hand side of the graph and the legend loses all the year descriptions. How do I fix this? Eric

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart shrinks when I add one more bar

    Hi SpartacusNZ,

    welcome to the forum.

    Can you upload a sample workbook after replacing actual data with dummy numbers ? thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    05-03-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Bar Chart shrinks when I add one more bar

    Thanks Dilip

    Sample charts attached showing a readable 9 year chart and an unreadable 10 year chart.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart shrinks when I add one more bar

    I found that data source for chart is on different workbook which is :-

    ='C:\Invoices\[Invoice Register 2012.xlsx]

    Try entering data in above workbook and then hopefully chart will show new data bar

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

  5. #5
    Registered User
    Join Date
    05-03-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Bar Chart shrinks when I add one more bar

    Hi Dilip

    That's the folder where I copied the chart from (where the problem originated). But even if you delete that and just point to the data on the chart I uploaded, you get exactly the same problem. 9 years is OK, 10 years is not.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Bar Chart shrinks when I add one more bar

    only way I can get the example you posted to misbehave is to set the set set of data to reference a different size of data to the others.
    Simply extending your example to include the last row of data does not affect the chart. Post workbook with the bad formatting and ensure the data referenced is local to the example file
    Cheers
    Andy
    www.andypope.info

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart shrinks when I add one more bar

    Okay.. I pointed to the data on the left side of the chart and found no issues

    Bar Graph Problem.xlsx

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

  8. #8
    Registered User
    Join Date
    05-03-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Bar Chart shrinks when I add one more bar

    Thanks Guys

    I just re-created the chart from scratch, and it was fine. Not sure what the problem was.

  9. #9
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart shrinks when I add one more bar



    that's why I really like the rule : "90% of your computer problem gets solved if you just 'RESTART'"


    Please mark this problem as [SOLVED]. Thanks.


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

  10. #10
    Registered User
    Join Date
    05-03-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Bar Chart shrinks when I add one more bar

    Hi Dillip

    How do I mark it as 'solved'.

    Eric

  11. #11
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart shrinks when I add one more bar

    Below is what I found in Forum Rules:-
    Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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