Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Run Chart problem

Copper Contributor

Hi,

I need some guidance on how to create a trending chart like the one below.

1. The Critical, Major, Minor has a scoring criteria that makes the lines moves.

2. The bar chart inside the plot area needs to be part of trend lines and should also have a scoring criteria

 

Thats all for now.  Thank you for those who will try to help out.

 

0 CRITICALS
OR
0 MAJORS
OR
0-7 MINORS
100%
 
90%
0 CRITICALS
OR
1 MAJOR
OR
8-15 MINORS
89%
 
70%
0 CRITICALS
OR
2 MAJORS
OR
16-23 MINORS
69%
 
60%
1+ CRITICALS
OR
3+ MAJORS
OR
24+ MINORS
59%
 
0%

 

 

NOVDECTCEBJANFEBMAR

NoelV1175_0-1700661740096.png

 

APRMAYJUNJULAUGSEPOCT

 

NOVDECTCEBJANFEBMARAPRMAYJUNJULAUGSEPOCT

 

 AVG
CRITICAL00000000000000.00
MAJOR00030010000000.31
MINOR24260110022011.62
COMMENT00000000010000.08
SELF-ASSESS000000000000110.85
TOTAL             #DIV/0!
CRITICAL100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%
MAJOR100.0%100.0%100.0%59.9%100.0%100.0%89.9%100.0%100.0%100.0%100.0%100.0%100.0%96.1%
MINOR95.0%90.0%95.0%85.0%100.0%97.5%97.5%100.0%100.0%95.0%95.0%100.0%97.5%96.0%
MAJOR + MINOR95.0%90.0%95.0%44.9%100.0%97.5%87.4%100.0%100.0%95.0%95.0%100.0%97.5%92.1%
METRIC95.0%90.0%95.0%44.9%100.0%97.5%87.4%100.0%100.0%95.0%95.0%100.0%97.5%92.1%
AVERAGE97.5%95.0%97.5%72.5%100.0%98.8%93.7%100.0%100.0%97.5%97.5%100.0%98.8%96.1%
MARGINAL69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%69.0%
UNSAT59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%
ROLLING AVG98.4%98.1%97.9%95.8%95.8%96.0%95.7%95.8%95.8%96.0%96.1%96.1%96.1%96.4%
1 Reply
Details Qty A #SPILL! B C D E F G H vlookup error is above.