View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sbweld@shaw.ca is offline
external usenet poster
 
Posts: 8
Default showing negative values as positive in a bar graph

Thanks for your help, I decided to go with the ABS function. When I
did the SUM for the total I just used a negative sign in the sum...
=sum(-L71,L72,-L73)


It seems like a bit of an unusual way... in my opinion. I can't
imagine my instructor did this the same way I did.

Thanks again
Sean