Bar chart with XY on secondary axis
 

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

Bar chart with XY on secondary axis
 

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/...olAndLine.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"casey" wrote in message
...
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

Bar chart with XY on secondary axis
 

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

"Andy Pope" wrote:

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/...olAndLine.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"casey" wrote in message
...
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