On Wed, 17 Jan 2007, in microsoft.public.excel.charting,
LU said:

I'm trying to create a bar chart with a line on it.

Problem is because it is percentage and very low the line
is at the bottom of the chart riding the x-axis.
I would like to have a line of data points over the bars to represent the
rate(percentages).

Assign the line series to the secondary axis. This is done by going into
the format dialogue for that series, selecting the "Axis" tab, and
changing the radio button under "Plot series on:" from "Primary axis" to
"Secondary axis".

Now your line series won't be so close to the bottom of the chart
compared to the bar series.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.