Clustered bar chart - bars not touching

Giganews Newsgroups
Subject: Clustered bar chart - bars not touching
Posted by:  j.ro…@statestreet.com
Date: 16 Jan 2007

Hi - I posted a question last week that no-one has answered, either its
impossible to do or I didn't phrase it properly!

Re: Clustered bar chart
I have monthly data ranges with 5 possible values, eg May has 5 sales
figures, June has 5 sales figures, July 06 etc.  When there are 5
non-zero values in one month the bars all touch each other and are
clearly defined as being from that month.  The bars represented are in
a series order defined in the options.    Where there are zero values
in a month, the series order remains and a space appears between the
bars.  For example, if the data in June is 5, 0, 0, 0, 4 the bars
appear at the extreme right and left of the range with nothing in
between.  This makes the graph difficult to 'read'.  Is there anyway
to ask the bars to touch, ie ignore zero-value bars?

Failing that, is there anyway to insert vertical dividers between each
month's data so that the data is clearly defined.

Previous question: unanswered.
I have a data range per month with 5 possible values.  When there are
non-zero results for all 5, the columns sit next to each other, which
is fine.  However I'd like the columns to sit next to each other for
only the non-zero values, ie if there only two rows in my data range
that have non-zero values, there should be two columns on my chart next
to each other with no gaps between them.  The range selection is as
follows: "=Sheet1!$A$61:$BD$66".  In short, I'd like the column chart
to ignore the 0 values in the data range and not to plot them or leave
a space for them.

Hope you can help!

Many thanks in advance
Joyce

Replies