View Single Post
  #5   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,
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