• 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.
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

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