Rookie here, so take it easy on me. I'm trying to make a simple chart that shows the cost to move into two separate locations, and I'd like to graphically show the variance between location A and B but not as a separate bar. Something like a dotted line between the two with the dollar amount shown. Ideas?
|Projects||Location A||Location B|
|Base CEC - 400||$ 8,275,685||$ 9,792,741|
|Incremental CEC - 505||$ 20,042||$ 1,521,014|
|Total CEC||$ 8,295,727||$ 11,313,755|
|Incremental EMS/Security||$ -||$ -|
|NET||$ 8,295,727||$ 11,313,755|