Changing gap depths

[JoAnn Paules]

I made a 3-D bar chart yesterday for the first time. My boss wanted
something a wee bit different than what I gave him (but he was happy with
the results). I had a chart that was 4 columns deep, 14 columns wide. Is
there a way to change the gap depth so that the first two and columns butt
up against each other? I played with the setting after giving him the chart
but I couldn't find anything that gave me that flexibility.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[Jon Peltier]

JoAnn -

Do you want a variable gap width? In general this isn't possible, but you
can fake it by skipping a row or column between all the other data, leaving
a space between existing columns because of the new zero height columns
corresponding to the added blanks. Change the gap width to 0, so the first
two are touching, and the rest will have an effective gap of 100%.

- Jon

 

[JoAnn Paules]

Oooh - that's good! Talk about creative thinking.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

JoAnn -

Do you want a variable gap width? In general this isn't possible, but you
can fake it by skipping a row or column between all the other data,
leaving a space between existing columns because of the new zero height
columns corresponding to the added blanks. Change the gap width to 0, so
the first two are touching, and the rest will have an effective gap of
100%.

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

I made a 3-D bar chart yesterday for the first time. My boss wanted
something a wee bit different than what I gave him (but he was happy with
the results). I had a chart that was 4 columns deep, 14 columns wide. Is
there a way to change the gap depth so that the first two and columns butt
up against each other? I played with the setting after giving him the
chart but I couldn't find anything that gave me that flexibility.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375