need to create a bar chart with a centre axis

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

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
 
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
 
You can always make the figures negative with =-A2
Andy has told you the best way to get the effect you are looking for
 
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
 
Back
Top