Bar chart - two vertical axis

Posted on 2011-04-28
Last Modified: 2012-06-21
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.
Question by:Frank Freese
    LVL 33

    Expert Comment

    LVL 33

    Accepted 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"

    Author Closing Comment

    by:Frank Freese
    the step by step was the difference in the two solutions. great job though and I appreciate you all.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now