Display Measurement Data and Bar Chart in Excel File (Workflow attached)

[kal-tech]

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

1. When you run the workflow it takes data from the input file and creates two files

• C:\temp\Output-File \ABC Corp.xlsx  (See ABC CORP File Below)
• C:\temp\Output-File \COE CORP.xlsx

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%

2. Take output file ABC Corp.xlsx . Put the above data grid and below bar chart in a excel file .

Issues :

1. The bar chart is not showing all month’s data in the X-Axis and legends number of Measurements
2. Can we omit #2 above and directly create aggregate data and Bar chart at the same time by agency and save the excel file.

Is there any suggestion how to display aggregated data and bar chart at the same time in the excel file.

[Qiu]

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

[kal-tech]

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 ?