ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code to Change Chart Type (https://www.excelbanter.com/excel-programming/272424-code-change-chart-type.html)

Pedro Marques

Code to Change Chart Type
 
Hi
I have made a code to create a Clustered Column Chart
What code should I write in order to change it to a Clustered Column with a
3D view but keeping the same size.
Whenever I do this he always make it smaller

Best Regards
Pedro




Tom Ogilvy

Code to Change Chart Type
 
I suspect you would need to record the size prior to the change, make the
change, then resize. Generally, Excel resizes because it is necessary to
accomplish what you want. I assume this is the case here, so in general,
you will need to control the size of the appropriate part of the chart and
let other parts of the charts size accordingly.

--
Regards,
Tom Ogilvy

"Pedro Marques" wrote in message
...
Hi
I have made a code to create a Clustered Column Chart
What code should I write in order to change it to a Clustered Column with

a
3D view but keeping the same size.
Whenever I do this he always make it smaller

Best Regards
Pedro







All times are GMT +1. The time now is 07:28 PM.

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