ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Labels on Clustered Column w/ 3D Visual effect (https://www.excelbanter.com/charts-charting-excel/53860-data-labels-clustered-column-w-3d-visual-effect.html)

emwashburn

Data Labels on Clustered Column w/ 3D Visual effect
 
Clustered Columns can have Alignment as "Inside End"

This doesn't seem possible with 3D Visual effect

Is there a way to resolve this?

Jon Peltier

Data Labels on Clustered Column w/ 3D Visual effect
 
Yes, use 2D charts. They provide a better representation of the values
being plotted without the implied false third dimension.

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


emwashburn wrote:

Clustered Columns can have Alignment as "Inside End"

This doesn't seem possible with 3D Visual effect

Is there a way to resolve this?


emwashburn

Data Labels on Clustered Column w/ 3D Visual effect
 

I prefer the way the 3D looks (I don't want to use 2D)

I was just wondering if I could have the 3D centre on the front face

"Jon Peltier" wrote:

Yes, use 2D charts. They provide a better representation of the values
being plotted without the implied false third dimension.

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


emwashburn wrote:

Clustered Columns can have Alignment as "Inside End"

This doesn't seem possible with 3D Visual effect

Is there a way to resolve this?



Jon Peltier

Data Labels on Clustered Column w/ 3D Visual effect
 
You can manually move individual labels. You need one single click to
select the series of labels, another single click to select the
individual label, and then drag it where you want it.

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


emwashburn wrote:
I prefer the way the 3D looks (I don't want to use 2D)

I was just wondering if I could have the 3D centre on the front face

"Jon Peltier" wrote:


Yes, use 2D charts. They provide a better representation of the values
being plotted without the implied false third dimension.

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


emwashburn wrote:


Clustered Columns can have Alignment as "Inside End"

This doesn't seem possible with 3D Visual effect

Is there a way to resolve this?



emwashburn

Data Labels on Clustered Column w/ 3D Visual effect
 
Yes, I know I can manually change them (I was looking for a way to set the
columns to automatically centre on the front face)

From what I gather, this isn't possible


"Jon Peltier" wrote:

You can manually move individual labels. You need one single click to
select the series of labels, another single click to select the
individual label, and then drag it where you want it.

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


emwashburn wrote:
I prefer the way the 3D looks (I don't want to use 2D)

I was just wondering if I could have the 3D centre on the front face

"Jon Peltier" wrote:


Yes, use 2D charts. They provide a better representation of the values
being plotted without the implied false third dimension.

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


emwashburn wrote:


Clustered Columns can have Alignment as "Inside End"

This doesn't seem possible with 3D Visual effect

Is there a way to resolve this?




All times are GMT +1. The time now is 05:20 PM.

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