charts

[Eric]

can you have numbers on your y axis on both sides of the chart? If so how
can I do it. I am trying to put english on the Left side and metric on the
right side of the graph ....HELP!

Eric

 

[Tim]

Eric,

I don't think you are looking for a VBA answer; this would have been better
posted in an excel charting newsgroup. And please don't post the same
question multiple times (3 times in 5 hours?!).

to plot the same data with two different y-axis i think it is necessary to
plot another set of data (in your case, the metric set). then right click
on the data series, choose 'format data series', choose the 'axis tab', then
'secondary axis'. then click the 'patterns' tab and set line and marker to
'none'. that way you'll have both y-axis but only one visible piece of
data.

hth,

Tim