Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Create combination chart in Excel 97

Posted on 2000-02-28
1
Medium Priority
?
194 Views
Last Modified: 2006-11-17
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
0
Comment
Question by:Rs
1 Comment
 
LVL 22

Accepted Solution

by:
ture earned 40 total points
ID: 2567998
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question