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

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

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