View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default changing gap width between specific columns

You said it yourself:

I know I can add space between columns if I insert an empty column in
the table.


If you have a reason you don't want your display data cluttered by empty
spaces, then copy the display regions, go to an empty worksheet or an out of
the way region of this sheet, and use Paste Special Links. Then insert blank
columns where needed and make your chart from this new range.

Worksheets are cheap, extra ranges do not cost much in this day of 200 GB
hard drives. Your time spent trying to get the chart the way you want
without using this abundant natural resource amounted to hours. I always
tell people, spending five minutes with the data will save five hours of
frustration (or is it ten minutes and ten hours?).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Noa" wrote in message
...
Hi Jon,
Series 1 and 2, each have 2 data sets.
This is how my data looks:

2000 2001 2002
data1 data2 data1 data2 data1 data2
a 50 70 55 70 80 60
b 20 30 15 10 10 20

a+b in each data column are stacked,. Now each column is presented
separated
from the other in the chart. I would like the stacked columns (datat1 and
data2) for each year to have no gap between them. I do want to keep the
gap
between each year. Is there a way to do that without changing the columns'
width? I know I can add space between columns if I insert an empty column
in
the table.

Thanks

"Jon Peltier" wrote:

I'm afraid I don't understand the problem. Are Series 1 and 2 stacked? If
so, how can they be in contact, other than to top of one touching the
base
of the other?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Noa" wrote in message
...
Thanks Jon.
I am using stacked Column chart, and not a Clustered Column chart. I
need
Series 1 and Series 2 to be in contact.

Thanks again
Noa

"Jon Peltier" wrote:

Do you have just one set of data? Set up the data like this:

[blank] Series 1 Series 2
Label 1 Data Data
Label 2 Data Data
Label 3 Data Data

Make a clustered column chart with series in columns. The series 1 and
series 2 columns above each label will be in contact, with a gap
between
the
data for label 1 and label 2, and between label 2 and label 3.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Noa" wrote in message
...
I have 2 data sets for each year, and would like each two to be
presented
without any spacing for each year. The spacing should remain between
each
year. Right now I have the same gap between all columns.
Changing the gap width or overlap using the Format data series does
not
do
the job.

Thanks
Noa