+ Reply to Thread
Results 1 to 4 of 4

Columns not displaying properly Excel 2007

  1. #1
    Registered User
    Join Date
    05-31-2017
    Location
    London UK
    MS-Off Ver
    2007
    Posts
    2

    Columns not displaying properly Excel 2007

    Hello

    I am quite new to Excel but have watched many tutorials to learn the basics and now ready to tackle more advanced functions.
    I have encountered a problem when creating column as it is not displaying properly and instead shows a mixup of the figures selected

    I have attached a screenshot

    Many thx for any feedback

    Thx Jon
    Attached Images Attached Images

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Columns not displaying properly Excel 2007

    Its hard to tell from the picture, but, are you using merged cells for the figures? If so, that is most likely what is causing the issue.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,254

    Re: Columns not displaying properly Excel 2007

    I agree that it is difficult to tell from a picture. What I see in the picture is that Excel has, for whatever reason, decided to put the data in the "series name" field instead of the values field. The first thing I would do would do with this chart is open up the Select Data dialog (https://support.office.com/en-us/art...9-5c70e374f9be ) and see what the chart is using for things. You should then be able to edit the different fields/ranges so that the chart is using the correct data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    05-31-2017
    Location
    London UK
    MS-Off Ver
    2007
    Posts
    2

    Re: Columns not displaying properly Excel 2007

    The document has 370 rows.
    Somehow if I select no more than 20-30 rows, it will display the columns , pie chart or any of the others correctly but if I select a higher number, it will not.

    Maybe this is linked to the amount of data it can display within a column or there might be a setting somewhere to increase the number of rows who will display

    Jon

+ 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. Excel 2007 : Fill handle not working properly
    By jhd in forum Excel General
    Replies: 7
    Last Post: 04-07-2016, 07:47 AM
  2. Styling doesn't work properly in excel 2007?
    By KasperH in forum Excel General
    Replies: 1
    Last Post: 08-28-2013, 03:44 AM
  3. Excel 2007 Formula files not opening properly in Excel 2010 #Name
    By irbalaji in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-26-2013, 02:13 AM
  4. Problem with macro not working properly on excel 2007
    By gfmout in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2012, 11:00 AM
  5. Word 2007 - How do I use columns properly?
    By DarkSoul in forum Word Formatting & General
    Replies: 3
    Last Post: 04-28-2011, 02:54 AM
  6. Excel 2007 pivot table does not aggregate properly
    By patrick23 in forum Excel General
    Replies: 0
    Last Post: 03-03-2011, 06:38 PM
  7. Replies: 4
    Last Post: 06-20-2008, 10:47 AM
  8. [SOLVED] PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007
    By Scott Dixon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2006, 10:55 AM

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