I want to replace the combo series with a single set of bars that show the difference between the Open and Close values for each month.

Need advice on building a bar chart. See attached image. I want to replace the combo series with a single set of bars that show the difference  between the Open and Close values for each month. If positive I get a positive bar, if negative I get a negative bar. I know there needs to be an OVER in the expression to do this, but right  now beyond my understanding level. Can anyone suggest a course of action?

 

thanks,

JP

Attachments

AttachmentSize
Image icon combo chart layout w data.PNG40.58 KB

(2) Answers

Login