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

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.

Reporting

Accepted answers

AngelosPachis

@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.

All comments

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

@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.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335