Forum Discussion
Maku12
2 years agoFrequent Visitor
Column chart with conditional formatting and positive or negative deviation at the top of the column
I have created the following diagram in Excel: It shows the sales budget per month (gray columns) and the respective overrun or underrun of the actual sales figures per month in green or red...
- 2 years ago
Hi Maku12
you can check this video which is similar to your problem statement: https://youtu.be/wDNxTwiPg8k?si=euP-d5vbJ-CujL78
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem
Regards - 2 years ago
Hi qqqqqwwwweeerrr,
thanks for solution proposal! Unfortunately the line for Sales of the Previous Year ia not shown, although I have selected it. - 2 years ago
Hi qqqqqwwwweeerrr , I seleced the Net Product Sales of 2022 in the filter for line Y-axis, which is a calculated measure that shows the Sales Amount of 2022, but nothing changed in the graph.
BR