| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing gap depths
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Changing gap depths
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 _______ "JoAnn Paules" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Changing gap depths
Oooh - that's good! Talk about creative thinking.
-- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Jon Peltier" wrote in message ... 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 _______ "JoAnn Paules" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cells in solver. | Excel Worksheet Functions | |||
| Automatically Changing File Links | Excel Discussion (Misc queries) | |||
| Changing the height of a row is very slow | Excel Discussion (Misc queries) | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Linear Mode
