Bar chart with XY on secondary axis

  • Thread starter Thread starter casey
  • Start date Start date
C

casey

I have four quarters of data that I display as a bar chart. I want to add
additional data superimposed on each (XY) as a secondary axis. However, the
XY coordinates are displayed on a single vertical axis in the center of the
bars rather than on each related bar.

Data:

(BAR) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
A 7.1 2.3 4.5 8.7
B 10.5 1.5 6.7 4.8
C 14.6 4.0 7.9 11.1

(XY) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
A 25 55 67 23
B 18 44 122 98
C 5 11 104 45
 
Yes and Yes. :-)

And I can say by looking at the final chart on this (Peltier's) link that
this will work perfectly for what I needed! Thanks, Andy.

Casey
 
Back
Top