Chart types in Excel

[pruleone]

Hy,

does anybody knows is it possible to make chart where I have about one person info in two different box.
I but a link to a drawing what might help to explain what I want to achive.

Source data:
First Second
1 xxx yyy
2 zzz ccc
3 sss bbb
4 eee ttt

and so on.

 

[SkipVought]

Hi,

Your source data:
[tt]
A B C D E
First second
22 44 22 44
33 33 33 33
44 44 44 44
33 22 33 22
[/tt]
Select A1:E5

Hit the Chart Wizard Toolbar Button

Select 100% Stacked Column

Data Range Tab: Series in ROWS

Series Tab: Categor axis: A1:E1

Finish

Right-Click any series and select Selected Object

Options Tab: Gap width 0







Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[pruleone]

It was helpfull but there was one problem for me.

It I turn gap with to 0 then all gaps are gone. But I want to that in chart between first (two collums) and second (two collums) would be some kind of gap.

Is that possible?

 

[SkipVought]

What is keeping you from increasing the gap?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JPaules]

If you have an open column between your two series and you do as SkipVoght said

Right-Click any series and select Selected Object
Options Tab: Gap width 0

It will work.

--
JP

 

[pruleone]

I will try it once more, but first time I did so, then if I change gap width to 0, then all caps between all coulumn did go away.
But as I said, I want that for ex two coulumn are gap with 0 and then there will be for ex gap 50, then two coulumn with 0 gap and so on.

Maybe I did something wrong in first time.

But thanks any way

 

[pruleone]

Ok, I did it again and still I can't to it has I want.

I did a cahrt, then I clicked right click in one coulumn and choosed format data series. Then I choosed options and from there I change gap width.

If I turn it to 0, then will all gap disapear.

 

[SkipVought]

Did you try changing the gap to ZERO?

Did you format your source data with one EMPTY column between the First and Second data groups?

It WORKS!!!!!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JPaules]

You *must* have that empty column between the data groups.

--
JP

 

[pruleone]

Thanks you all,

now I understand what I did wrong - there wasn't empty column

 

[JPaules]

Funny how something as simple as nothing can make a world of difference, isn't it?

--
JP

 

[pruleone]

Yes