Stacked Column Chart with gaps!
in [Charts]
|
From: James on 4 Nov 2009 13:25 Hi all Has anyone got any ideas how I can create a stacked chart but the next column starts from what what you expected rather than what you ended up on. To explain better say I have two targets (100 and 100 to make it easy) yes for the first target I only achieve 80. In one bar how do I show the 80 then a gap for the 20 and then start from 0 again? So if they were coloured the bar would look something like red (representing 80), white (20) then red again for the second target? Hope this makes sense! -- James.
From: Luke M on 4 Nov 2009 16:24 Create a dummy series of data, calcualted by something like =A2-B2 Have this series plotted between series A and B. Then, format the column to have no color, no border. you can then change the color of series B to match series A. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James" wrote: > Hi all > > Has anyone got any ideas how I can create a stacked chart but the next > column starts from what what you expected rather than what you ended up on. > To explain better say I have two targets (100 and 100 to make it easy) yes > for the first target I only achieve 80. In one bar how do I show the 80 then > a gap for the 20 and then start from 0 again? So if they were coloured the > bar would look something like red (representing 80), white (20) then red > again for the second target? > > Hope this makes sense! > > > -- > James.
|
Pages: 1 Prev: display a Calculated Item in Data Label Next: Single Series Stacked Column - HELP |