Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart with gaps!
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart with gaps!
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Transpose Column With Gaps to Column With no gaps | Excel Discussion (Misc queries) | |||
Stacked chart with data gaps | Charts and Charting in Excel | |||
Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |