Bar chart with XY on secondary axis

[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

 

[Andy Pope]

Hi,

By bar I assume you mean Column and XY you mean Line, or XY without
specifying the X values.

Anyway here is how to over come the problem.
http://peltiertech.com/Excel/Charts/ClusterColAndLine.html

Cheers
Andy

 

[casey]

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