One extra x axis item that wont go away - can anyone help?

Discussion in 'Excel Charting' started by Mark Stephens, Apr 21, 2014.

  1. Hi there,

    I have set up a dynamic chart using named ranges. Here's a description of how it is set up, hopefully when you have seen it in its totality someone will be able to help me get rid of the extra item, I have tried everything I can to no avail.

    The source sheet for the chart is on a sheet named Source3 which consists of column A from A1 to A40 numbered 1 to 40. Column 2 contains values populated from and array which clears the existing values before being deposited in column B from B1 to B however many values there are (that's the dynamic bit).

    The chart is a simple bar chart in another sheet in the same workbook namedCHARTS

    I have two named ranges: First Cht3_SRC which is referenced:


    And Chart3Labels referenced:


    My chart works beautifully except that the x axis has one blank item more than it should have (i.e. if the series in Source3 column B has 5 items it shows a chart correct in every respect except that it has a sixth blank itemon the x axis.

    Can anyone help?

    Thanks and regards, Mark
    Mark Stephens, Apr 21, 2014
    1. Advertisements

  2. Mark Stephens

    Claus Busch Guest

    Hi Mark,

    Am Mon, 21 Apr 2014 00:29:40 -0700 (PDT) schrieb Mark Stephens:

    Claus B.
    Claus Busch, Apr 21, 2014
    1. Advertisements

  3. Hi Claus,

    Thanks for your speedy reply, unfortunately didn't correct it, kind regards, Mark
    Mark Stephens, Apr 21, 2014
  4. Hi CLaus, I stand corrected I didn't copy your solution correctly first time, when I did it corrected it thank you so so much, really appreciate your help, kind regards, Mark
    Mark Stephens, Apr 21, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.