ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Question clustered column w/3D visual effect (https://www.excelbanter.com/charts-charting-excel/240981-question-re-clustered-column-w-3d-visual-effect.html)

Meenie

Question clustered column w/3D visual effect
 
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
thanks, Meenie

Jon Peltier[_2_]

Question clustered column w/3D visual effect
 
This should be a hint to avoid the 3D effects. 3D charts are inflexible,
but more important, the 3D effects mask the information in the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Meenie wrote:
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
thanks, Meenie


Meenie

Question clustered column w/3D visual effect
 
thanks Jon.
That's a bit of a bummer. It made a nice looking little chart with the
columns looking like 2x4's :) but I couldn't change the sizing of anything.
I thought it was just me. I hadn't played with the 3D charts before. It was
kind of neat the way you could tilt and turn them. But that was all I could
get them to do. When I went to Options and changed the gap width and other
options there, it barely changed anything.
Guess I'm glad to know it isn't ME this time <G
Meenie

"Jon Peltier" wrote:

This should be a hint to avoid the 3D effects. 3D charts are inflexible,
but more important, the 3D effects mask the information in the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Meenie wrote:
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
thanks, Meenie



Jon Peltier[_2_]

Question clustered column w/3D visual effect
 
Remember that nice looking doesn't mean it's an effective display.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Meenie wrote:
thanks Jon.
That's a bit of a bummer. It made a nice looking little chart with the
columns looking like 2x4's :) but I couldn't change the sizing of anything.
I thought it was just me. I hadn't played with the 3D charts before. It was
kind of neat the way you could tilt and turn them. But that was all I could
get them to do. When I went to Options and changed the gap width and other
options there, it barely changed anything.
Guess I'm glad to know it isn't ME this time <G
Meenie

"Jon Peltier" wrote:

This should be a hint to avoid the 3D effects. 3D charts are inflexible,
but more important, the 3D effects mask the information in the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Meenie wrote:
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
thanks, Meenie



All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com