Does Alteryx has Export-Excel Chart Function like in the PowerShell?

[adluayon]

Hi Support,

I want to create a excel files will multiple sheets & charts & pivot charts.
It is very easy in PowerShell using Import-Excel Module.
But i wonder does Alteryx Designer also has this type of functions?

1. Create Excel
2. Create Sheet1, Sheet2, Sheet3

3. Populate Sheet1 with Raw Data

4. Populate Sheet2 with Line Chart

5. Populate Sheet3 with Pivot Chart using Pie.

Thanks.

[AngelosPachis]

Hi @adluayon ,

Yes Alteryx can do everything you mentioned. Points 1-3 are dependent on how you configure the output data tool and points 4-5 need tools included in the reporting tool palette. However, your charts will not read data from the Raw Data tab but they will be static, so if someone opens that Excel and adds more data to the Raw Data tab, the charts won't update

[adluayon]

Hi @AngelosPachis 

Output Data Tools has Overwrite File & Create New Sheet which will solves the 1-3.
But 4 - 5 I cannot even used Interactive Chart & Render.
Any other workaround on this? 
Where the pivot charts is automatically generated based on the raw data?
I prefer the chart will read the raw data not static.

In powershell using only this command solves the problem.

$chart = New-ExcelChartDefinition -XRange Name -YRange Count -Title "Usage - $(get-date $sdate -f "MM-dd-yyyy")" -NoLegend
$countData | Export-Excel $file -Append -WorksheetName "Count Data" -AutoSize -TableName Log -title "Count - $(get-date $sdate -f "MM-dd-yyyy")" -TitleBold -AutoNameRange -ExcelChartDefinition $chart

[AngelosPachis · Accepted solution]

@adluayon I guess then the best option is to first manually create your charts to read data from the raw data tab and then overwrite that data with whatever comes out from Alteryx.

[adluayon]

@AngelosPachis 

Thanks for the insight.
Kinda wonder why this software is license but lack of excel chart features.