Excel Graph Dual Axis question 1

[Scott02]

I'm working on a graph and trying to use the Line-Column on two axis style, but can't seem to get the data to hit the right locations on the graph. Here's a sample of the data:

Admissions Friendly Cleanliness Speed
January 100,000 75% 80% 85%
February 101,000 76% 81% 86%
March 102,000 77% 82% 87%
April 103,000 78% 83% 88%

I'd like to get the admissions as a column and the other 3 as data sets as lines on the graph. But what keeps happening is I get admissions and Friendly as columns and the last two as lines. I added a column between admissions and Friendly with "Blank" heading and 0 values, just to see if it pulled the first two sets as columns, but instead, it pulled the first three (Admiss,Blank,Friendly) and plotted them as columns and the last two as lines. Is there anyway to get more than just the last two as lines in the graph? Does this style automatically take everything BUT the last two data sets as columns? Any help would be appreciated.
Scott

 

[SkipVought]

Hi,

Select the SERIES in the chart, that you want to change.

Chart > Chart Type...

and select the chart type you want.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Scott02]

That worked to change it to a line, then I still had to format it and change the axis from primary to secondary. Worked like a charm. Thanks a bunch Skip!
Scott