Add a parameter to specify the ChartStyle

[lucdekens]

This would replicate the Chart Layouts on the Design tab in Excel.
Not sure if this is possible at all.

[dfinke]

Added a chart style in this branch 1ef6e66

There are some 48 styles in the enum, named Style1..48. They do change the chart look, Looks like a style # may only apply to a chart type, Needs investigation.

Gives the chart a 3D type look

[lucdekens]

Yes, that works, thanks Doug.

The information on these Styles is rather scarce it seems.
No enumeration info I can find.

These 2 StackOverflow threads seem to hold some more info.
https://stackoverflow.com/questions/38813522/themed-chart-styles-for-excel-charts-using-vba
https://stackoverflow.com/questions/27889579/what-does-the-number-in-the-addchart2-vba-macro-represents

[lucdekens]

This Excel holds a sample of all the styles
https://onedrive.live.com/view.aspx?resid=CC8D18389663F4C7!54425&ithint=file%2cxlsx&app=Excel&authkey=!ADUXdSANPTS1r_Q

[haydeniv]

Did this ever get added to a release?

[dfinke]

I believe so. Just thinking of the top of my head though.

[haydeniv]

I tried to use the -ChartStyle parameter in 7.8.6 and got:
New-ExcelChartDefinition : A parameter cannot be found that matches parameter name 'ChartStyle'.

[dfinke]

pls post the repro, script etc