Posted to microsoft.public.excel.charting
|
|
Floating Bar Chart
Thank you thats perfect!
"Andy Pope" wrote:
Hi,
Create a clustered column chart.
Format the series to have an overlap value of 100.
Change the series order so B is plotted infront of C.
Format series B to have no border and the same fill colour to be same as
plotarea.
Cheers
Andy
Andy the Yeti wrote:
Hi,
Is it possible to create a vertical floating bar chart, where the start of
the bars value will equal the value in column b and the end of the bars value
equal the value of column C (the length of the bar when then represent the
gap within B & C)?
Here is my data table (so I would have 5 seperate bars)
A B C
1 28207 29,970
2 40488 43,019
3 39029 41,468
4 53350 56,684
5 44851 48,055
Many thanks for any help or direction
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
|