• 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.
Frank Freese
Frank Freese
  • 2
1 Solution
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"
Frank FreeseAuthor Commented:
the step by step was the difference in the two solutions. great job though and I appreciate you all.
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