Floating Bar Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you thats perfect!




Andy Pope said:
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
Click to expand...
 
Back
Top