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

Hi,

Sounds like a Tornado chart.

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html

Cheers
Andy

Gover wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

"Andy Pope" wrote:

Hi,

Sounds like a Tornado chart.

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html

Cheers
Andy

Gover wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

You can always make the figures negative with =-A2
Andy has told you the best way to get the effect you are looking for
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gover" wrote in message
...
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

"Andy Pope" wrote:

Hi,

Sounds like a Tornado chart.

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html

Cheers
Andy

Gover wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

Gover wrote:
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

"Andy Pope" wrote:


Hi,

Sounds like a Tornado chart.

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html

Cheers
Andy

Gover wrote:

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, Microsoft MVP - Excel
http://www.andypope.info