Can't recover PlotArea Format Texture Fill Offset

lsokal

New Member
Joined
Mar 22, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi,

I am trying to automate a process and need to recover the properties of user defined charts in excel files.
I am developing a tool with Python but since it's using the COM interface an answer in VBA should help also (pywin32) although I am unfamiliar with it.

I have tons of trouble recovering the "offset properties" that you can see in the picture below (ie offset left 90%).

.PlotArea.Format.PictureFormat.CropLeft (or Right/Bot/Top) is defined but gives me a value equals to 0.0 which is odd.

I have no problem recovering the transparency for example (here 30%), with .PlotArea.Format.Fill.Transparency

I tried various other properties such as .PlotArea.Format.Fill.TextureOffsetX etc. without any success.

I Tried using the "Record macro" tool to change those values and see what properties are affected but it actually gives me empty lines !

Could any of you guys help with this issue?

Thanks a lot !

1616425873677.png
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

lsokal

New Member
Joined
Mar 22, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Just to add up: when creating chart from scratch while recording a macro, the step "Picture Texture Fill" is simply ignored.

Is this a bug ? If so, is there another way to recover this property ?
 

lsokal

New Member
Joined
Mar 22, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows

jdjehanneman

New Member
Joined
Mar 23, 2021
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Hi Isokal,

I was just about to post the same question as yours. I need to set the "offset properties" of the texture fill for the plot area but I can't find the right properties to do so. My searches on the net didn't help me.
I'm hoping someone will post a solution for this issue.

Thx in front
 

Watch MrExcel Video

Forum statistics

Threads
1,129,689
Messages
5,637,837
Members
416,985
Latest member
mrindira

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top