How to Add Percentage Increase/Decrease Numbers to a Graph Trendline

%3CLINGO-SUB%20id%3D%22lingo-sub-2378913%22%20slang%3D%22en-US%22%3EHow%20to%20Add%20Percentage%20Increase%2FDecrease%20Numbers%20to%20a%20Graph%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378913%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20an%20example%20graph%20I%20have%20made%20to%20show%20the%20percentage%20grading%20of%20audits.%20The%20visible%20numbers%20on%20the%20'TOTAL%20GRADE'%20line%20are%20the%20graded%20numbers.%20I%20inserted%20a%20trendline%20called%20'%25%20PERCENTAGE%20TRENDLINE'%20because%20I%20want%20a%20secondary%20line%20to%20show%20the%20percentage%20differences%20between%20the%20interval%20grading.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20the%20first%20two%20grades%2C%2053%25%2C%20and%2045%25%20have%20a%20difference%20decrease%20in%20the%20percentage%20of%26nbsp%3B%3CSPAN%3E16.3265%25%20or%2016.32%25%20for%20short.%20I%20want%20'16.32%25'%20((insert%20downward%20arrow%20here)%20symbol%20for%20decrease))%20to%20be%20visible%20on%20the%20trendline%20(secondary%20white%20line)%20in%20between%20the%20graded%20numbers%20of%2053%25%20and%2045%25.%20This%20would%20make%20seeing%20the%20total%20results%2C%20and%20their%20percentage%20differences%20easy%20to%20see%20on%20the%20same%20flowchart.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20ideas%3F%20I%20have%20been%20looking%20for%20hours.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Trendline%20Graph.PNG%22%20style%3D%22width%3A%20767px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282953iA36EE9E855157F23%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Trendline%20Graph.PNG%22%20alt%3D%22Trendline%20Graph.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378987%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20Percentage%20Increase%2FDecrease%20Numbers%20to%20a%20Graph%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061034%22%20target%3D%22_blank%22%3E%40Gamerxzy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20know%20how%20you%20arrive%20at%2016.32%25%2C%20but%20here%20is%20a%20rather%20tricky%20way%20to%20do%20it.%20In%20the%20attached%20workbook%2C%20I%20inserted%20dates%20in%20between%2C%20and%20used%20these%20for%20a%20series%20that%20plots%20the%20average%20between%20the%20values%2C%20but%20without%20a%20line%2C%20and%20for%20the%20percentage%20increase%2Fdecrease%20to%20be%20used%20as%20data%20labels.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chart.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282971iB8FD26F89FBA11B4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chart.png%22%20alt%3D%22Chart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379064%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20Percentage%20Increase%2FDecrease%20Numbers%20to%20a%20Graph%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BHey%20Hans.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20It%20won't%20allow%20me%20to%20directly%20insert%20a%20date%20into%20the%20graph.%20If%20I%20insert%20a%20date%20outside%20the%20graph%20and%20attempt%20to%20move%20it%20into%20the%20desired%20position%2C%20then%20it%20seemingly%20goes%20behind%20the%20graph%20and%20is%20invisible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20%22For%20the%20percentage%20increase%2Fdecrease%20to%20be%20used%20as%20data%20labels.%22%20Are%20these%20actually%20inserted%20data%20labels%20based%20on%20one%20of%20the%20lines%2C%20or%20are%20you%20just%20calling%20them%20that%20because%20that's%20what%20they%20look%20like%20from%20your%20alternative%20method%20as%20inserted%20dates%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20I%20will%20be%20adding%20information%20to%20this%20graph%2C%20and%20graphs%20like%20this%20a%20lot.%20This%20will%20also%20mean%20I%20may%20have%20to%20constantly%20change%20the%20sizing%20of%20the%20graph%20over%20time.%20Wouldn't%20it%20mean%20that%20inserting%20dates%20as%20a%20workaround%20would%20be%20impractical%20in%20this%20scenario%3F%20If%20that's%20the%20case%2C%20should%20I%20just%20leave%20them%20out%20and%20have%20them%20visible%20in%20another%20graph%2Ftable%20alternatively%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20to%20hassle%20you%2C%20just%20trying%20to%20understand.%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379115%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20Percentage%20Increase%2FDecrease%20Numbers%20to%20a%20Graph%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061034%22%20target%3D%22_blank%22%3E%40Gamerxzy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20data%20labels%20have%20been%20added%20to%20the%20series%20based%20on%20the%20series%20in%20D2%3AD8.%3C%2FP%3E%0A%3CP%3EYou%20don't%20see%20this%20series%20because%20I%20set%20that%20series%20to%20use%20'No%20line'.%3C%2FP%3E%0A%3CP%3EBut%20this%20design%20is%20not%20practicable%20if%20you%20have%20to%20extend%20the%20data%20frequently%2C%20it'd%20require%20too%20much%20fiddling.%3C%2FP%3E%0A%3CP%3ELet's%20see%20if%20someone%20else%20comes%20up%20with%20a%20better%20idea.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

Below is an example graph I have made to show the percentage grading of audits. The visible numbers on the 'TOTAL GRADE' line are the graded numbers. I inserted a trendline called '% PERCENTAGE TRENDLINE' because I want a secondary line to show the percentage differences between the interval grading.

 

For example, the first two grades, 53%, and 45% have a difference decrease in the percentage of 16.3265% or 16.32% for short. I want '16.32%' ((insert downward arrow here) symbol for decrease)) to be visible on the trendline (secondary white line) in between the graded numbers of 53% and 45%. This would make seeing the total results, and their percentage differences easy to see on the same flowchart. 

 

Any ideas? I have been looking for hours.

 

Trendline Graph.PNG

3 Replies

@Gamerxzy 

I don't know how you arrive at 16.32%, but here is a rather tricky way to do it. In the attached workbook, I inserted dates in between, and used these for a series that plots the average between the values, but without a line, and for the percentage increase/decrease to be used as data labels.

 

Chart.png

 

@Hans Vogelaar Hey Hans.

 

1. It won't allow me to directly insert a date into the graph. If I insert a date outside the graph and attempt to move it into the desired position, then it seemingly goes behind the graph and is invisible. 

 

2. "For the percentage increase/decrease to be used as data labels." Are these actually inserted data labels based on one of the lines, or are you just calling them that because that's what they look like from your alternative method as inserted dates?

 

3. I will be adding information to this graph, and graphs like this a lot. This will also mean I may have to constantly change the sizing of the graph over time. Wouldn't it mean that inserting dates as a workaround would be impractical in this scenario? If that's the case, should I just leave them out and have them visible in another graph/table alternatively?

 

Sorry to hassle you, just trying to understand. Thanks in advance!

@Gamerxzy 

The data labels have been added to the series based on the series in D2:D8.

You don't see this series because I set that series to use 'No line'.

But this design is not practicable if you have to extend the data frequently, it'd require too much fiddling.

Let's see if someone else comes up with a better idea.