• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1133
  • Last Modified:

Bar chart - two vertical axis

Here's my data:

April      WK1      WK2      WK3
Total Units       1,136,942        643,838        614,428
OB Per Units Cost       $0.040        $0.068        $0.075

I need a bar chart on the total units and a line for the per unit cost. Total units would be the primary axis and th per unit the secondary axis. I cannot get there...a step by step would be greatly appreciated.
0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
jppintoCommented:
0
 
jppintoCommented:
1. Create a normal line chart with both series
2. Select the Total Units line on the chart, right click and select "Change Series Data Type"
3. Select a bar chart from your options.
4. Right Click on your line series (Per Units Cost), select Format Data Series and change the "Plot Series on" to "Secondary Axis"
Capturar.JPG
0
 
Frank FreeseAuthor Commented:
the step by step was the difference in the two solutions. great job though and I appreciate you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now