View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Noa Noa is offline
external usenet poster
 
Posts: 11
Default changing gap width between specific columns

Hi Jon,
I understand what you mean. We found a way to add gaps between columns but
we didn't find a way to remove gaps between data1 and data2 columns (there is
no empty column between them in the table). I wanted the chart to look just
like a clustered chart would have looked (with only one row for each data1,
data2 set).
I will leave it this way. It's ok.

Thanks


"Jon Peltier" wrote:

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