• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1128
  • 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.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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