Forum Discussion
Problem with negative numbers in charts
Hi! Im doing "net worth monitoring" in Excel on monthly basis. There is a lot of positive numbers like bank accounts balance, stock market balance and so on... But also there is negative numbers as f...
Thank you Patrick! That would work if I would do this chart for only one month but my purpose is to monitor it every month and put information about the situation at the end of the month. So basically there should be timeline on x-axis where is bar for every month. If you understand what I mean. I'm using stacked column chart.
Why not add one more series for the total and overlay that one as a line, like in the picture below?
