Different width of columns (series) in clustered charts
 

Hi,

Using Excel 2000, does anyone know if it is possible to have the columns for
each of 2 different data series be of different widths?

Rather than have the columns for each side-by-side, I wanted to have them on
top of each other, but with the €œtop€� series narrower 5than the other so both
could be seen.

I set the series overlap to 100% to achieve the first part, but cant figure
out how to manipulate the widths directly. I tried to do this indirectly
changing the gap width, but it changes it for both series!

Is what Im trying to achieve possible in Excel 2000?

Many Thanks for any suggestions

plot both sets of data
on the graph select one column and change its axis to secondaary

Now you can change the widths independantly


"Bamboozled" wrote:

Hi,

Using Excel 2000, does anyone know if it is possible to have the columns for
each of 2 different data series be of different widths?

Rather than have the columns for each side-by-side, I wanted to have them on
top of each other, but with the €œtop€� series narrower 5than the other so both
could be seen.

I set the series overlap to 100% to achieve the first part, but cant figure
out how to manipulate the widths directly. I tried to do this indirectly
changing the gap width, but it changes it for both series!

Is what Im trying to achieve possible in Excel 2000?

Many Thanks for any suggestions

Very helpful!

Thanks very much bj,

(slightly less) bamboozled


"bj" wrote:

plot both sets of data
on the graph select one column and change its axis to secondaary

Now you can change the widths independantly