+ Reply to Thread
Results 1 to 3 of 3

Column Chart Not Working if First Column has Zero

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Column Chart Not Working if First Column has Zero

    Hi,
    I've attached a sample. In the sample, if the last row (year 2013) is removed from the data selected, the chart works. When included, that data point is the only one shown. I've spent an hour on this. Can anyone help? I need to present it in the order I have it.

    SampleProblem.xlsx
    Last edited by ker9; 03-28-2014 at 10:36 AM.

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

    Re: Column Chart Not Working if First Column has Zero

    Increate the height of the chart object to about 60cm (down to row 150).

    That should reveal the reason why you think the chart is not working.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Re: Column Chart Not Working if First Column has Zero

    Thank you! (Feel stupid)

+ 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] Setting individual column width sizes for multi column listbox with VB2011 Mac not working
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-26-2014, 06:19 PM
  2. Macro from moving from column 12 to the next row of column 5 not working
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2013, 05:58 PM
  3. Dynamic chart not working with stacked column
    By simonzxr in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-27-2012, 08:09 AM
  4. Need copy the column d instead of column b, macro working fine for column b
    By audax48 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2012, 04:32 PM
  5. [SOLVED] Stacked Column Chart / Normal Column Chart
    By Rowan Drummond in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2006, 12:00 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