LogFAQs > #974309445

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, DB5, DB6, DB7, DB8, DB9, DB10, DB11, Database 12 ( 11.2023-? ), Clear
Topic List
Page List: 1
TopicNeed Excel help - charts
MartinFF7
06/21/23 12:57:36 PM
#8:


Stacked bar chart and then set the part of the bar from 0 to the min value to be no colour/transparent. So the visible bar chart would show the "difference" between the starting and ending values which would be the bottom and top of the bar and the label for that bar would represent the difference amount.

How to also get labels on there also showing the starting and ending values... that's probably needing a second chart on a secondary axis using the same scale.

Steiner's reco is also pretty good especially if you want to show percentage rather than absolute value differences.

(like 20 years of using Excel and I'm still terrible at making charts, lol...)
... Copied to Clipboard!
Topic List
Page List: 1