need to create a bar chart with a centre axis

[Guest]

Need to create a chart with a centre axis, with one comparison going to the
left, from zero to 22 and another set of data goin to the right with a
comparison set of figures - if this makes any sense

 

[Andy Pope]

Hi,

Sounds like a Tornado chart.

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/software/tornado/index.html

Cheers
Andy

 

[Guest]

Thanks, but my figures are not negative.
A bit more info. Have two sets of figures per category eg Cat & Doy: cat=
15, cat =5 then dog =12 and dog= 3.
Need the cat figures to compare one under the other going from the middle
of the chart to the left and the dog figures going to the right??

thanks anyway

 

[Bernard Liengme]

You can always make the figures negative with =-A2
Andy has told you the best way to get the effect you are looking for

 

[Andy Pope]

It is possible to do it without altering your data.

You need to use 2 axis, change the secondary value axis to be in reverse
order, fix the min/max values of both scales, change the number formats.

Using a set of charting data is more straight forward.

Cheers
Andy