Hello,
Hoping someone will be able to help as I've hit a brick wall!!
I have created bullet charts to show finance and performance all on one chart for all the organisations we work with. The performance side of things works well but the finance only works if the organisation has either spent everything that was given to them or they have under-spend which means they still have money left over. But when the organisation has overspent meaning they have used their own money on top of what has been paid to them then this figure on the bullet chart is shown as a negative figure and falls below 0% on the chart and messes the chart up!!
I don't know how to fix this, one of my colleague suggested doing an IF statement but I have no idea how to do this either. I have googled and googled but have got nothing.
I hope this makes sense and someone will be able to help
Many thanks
Nusrat
Hoping someone will be able to help as I've hit a brick wall!!
I have created bullet charts to show finance and performance all on one chart for all the organisations we work with. The performance side of things works well but the finance only works if the organisation has either spent everything that was given to them or they have under-spend which means they still have money left over. But when the organisation has overspent meaning they have used their own money on top of what has been paid to them then this figure on the bullet chart is shown as a negative figure and falls below 0% on the chart and messes the chart up!!
I don't know how to fix this, one of my colleague suggested doing an IF statement but I have no idea how to do this either. I have googled and googled but have got nothing.
I hope this makes sense and someone will be able to help
Many thanks
Nusrat