Forum Discussion

Maku12's avatar
Maku12
Frequent Visitor
2 years ago
Solved

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...
  • Maku12's avatar
    Maku12
    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.

     

     

  • Maku12's avatar
    Maku12
    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