Superimposing graphs
 

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

Tm SV SP DV DP Rate
1 8606 17565 1581 1769 94.60%
2 9118 17941 3241 2863 85.00%
3 9056 23163 5540 4916 94.20%
4 10307 50435 6393 7935 90.80%

Tm will be x-axis
SV,SP,DV,DP will be bars
Rate will be a line across top of bars

Here is what I tried. Created bar chart, next selected 'rate' and changed to
line type chart. 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).

Superimposing graphs
 

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.