3D Area Charts

49 views
Skip to first unread message

Iulian Danciu

unread,
Sep 27, 2022, 10:43:24 PM9/27/22
to openpyxl-users
Hello, 

I am searching for a little help from you regarding 3D Area Charts.
I managed to create the 3-D Area, but now i have to modify some settings (rotation, depth, etc.)
Precisely, I do not know how to handle the settings from the Format Chart Area(especially Depth (% of base)) . Below is a picture: 

Thanks! 
Capture.JPG

Charlie Clark

unread,
Sep 29, 2022, 3:23:12 PM9/29/22
to openpyxl-users
The best thing to do is to look at the XML source of the chart and setting the options manually.
Charts are unbelievably complex but I'm pretty sure the relevant options are in the relevant chart class.

All the options are documented in the OOXML specification.

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Waldlehne 23
Düsseldorf
D- 40489
Mobile: +49-178-782-6226

Lucian Popescu

unread,
Sep 29, 2022, 3:26:35 PM9/29/22
to openpyx...@googlegroups.com
Charlie,
Please delete my email: lupo...@rogers.com from the email list.
I unsubscribed several times with no effdct.
It is annoying!

Thank you and much appreciated.
Best Regards,

Lucian

Sent from my iPhone

> On Sep 29, 2022, at 3:23 PM, Charlie Clark <charli...@clark-consulting.eu> wrote:
> --
> You received this message because you are subscribed to the Google Groups "openpyxl-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to openpyxl-user...@googlegroups.com.
> To view this discussion on the web, visit https://groups.google.com/d/msgid/openpyxl-users/81888341-49E6-4122-B893-EC286F6217CF%40clark-consulting.eu.
Reply all
Reply to author
Forward
0 new messages