OPEX and CAPEX in Bar Graph

[Koejns]

I have a question on drawing bar graphs. I have calculated CAPEX and OPEX prices with a max point and a min point. Now I want Excel to produce a graph that shows the min point as the minimum and than a bar up to the max point with a point for normal CAPEX/OPEX. Is this possible?

 

[baitmaster]

Its possible, but may need a bit of playing around to understand how. Create a stacked bar graph, with the first value having no colour. The first value will go from 0 to your min, the next value will go from your min to your max, but will have a value of (max - min), if that makes sense...

 

[Koejns]

Thanx! Got it now!