Create combination chart in Excel 97

I've got 3 columns of data: Date, Volume, and Value.

I'm trying to make a chart showing a line graph between the date and value. Then using the other y-axis (on the same graph) have a bar graph showing volume vs date.  I know this is possible, but Excel help is practically usless on how to go about it.
Thanks
RsAsked:
Who is Participating?
 
tureConnect With a Mentor Commented:
Rs,

1. Create a line graph (both Volume and Value as lines).
2. Right-Click anywhere on the the Volume line and select 'Chart Type', Select 'Column' - OK
3. Right-Click one of the Volume columns and select 'Format Data Series'
4. On the 'Axis' tab, select 'Secondary Axis' - OK

Ture Magnusson
Karlstad, Sweden
0
All Courses

From novice to tech pro — start learning today.