Hi
Display data and bar chart in an excel file for each agency
Supplied : Workflow, Input Data file , Output File file containing Bar chart
C:\temp\Input-File \ HVC Raw Data-Test.xlsx
C:\temp\Output-File\ ABC Corp.xlsx
COE CORP.xlsx
Bar Chart-ABC Corp.xlsx
Workflow : WorkflowCampaign-Test.yxwz
Agency | Year-Month | Project Count | Sum_Pass | Sum_Fail | Sum_SS | Agency Score Percent |
ABC Corp | 2024/05 | 3 | 23 |
|
| 100% |
ABC Corp | 2024/04 | 4 | 4 | 9 | 1 | 81% |
ABC Corp | 2024/03 | 4 |
|
|
| 100% |
ABC Corp | 2024/02 | 4 |
|
|
| 100% |
ABC Corp | 2024/01 | 4 |
|
|
| 100% |
ABC Corp | 2023/10 | 4 | 2 |
|
| 88% |
ABC Corp | 2023/08 | 1 | 2 | 3 |
| 95% |
ABC Corp | 2023/07 | 3 | 2 | 8 | 3 | 83% |
ABC Corp | 2023/05 | 2 |
|
|
| 100% |
ABC Corp | 2023/04 | 4 |
|
|
| 100% |
ABC Corp | 2023/03 | 4 | 6 | 20 |
| 82% |
ABC Corp | 2023/02 | 4 | 14 | 23 | 3 | 89% |
ABC Corp | 2023/01 | 4 |
|
|
| 100% |
Issues :
Is there any suggestion how to display aggregated data and bar chart at the same time in the excel file.
@kal-tech
I did not quite understand your 2nd question, but for 1st one, I made some adjustment on the X, Y Axis setting and insert a Sorting tool, now it looks alright.
Hi Qiu:
Thank you for attempting to address the issue.
I add a filter condition to display all rows in the chart that have pass, fail and SS > 0 and add the filter condition descending. I also keep your suggestion X-Axis Min = 0 and MAX = 18. I can see Bar chart now.
Issue #1 : The Legends values are not showing for Tall Bars.
Issue #2 : I want the 2024/05 Pass, Fail, and SS bar numbers to show, followed by some spaces, and then the 2024/04 bar numbers to display. The Layer --> ‘Bar mode = Group’ is grouping the bars together, which is good. How can I increase the spaces between the X-Axis dates at the bottom?
Issue#3 : I am running two workflows: one to populate the data for the bar chart, and then a second workflow to input data from the first workflow to populate the bar chart in Excel. Can we run a single workflow to show the data & bar chart both in Excel ?