Microsoft Excel Graph 3 series of data

Posted on 2009-12-24
Last Modified: 2013-12-27
I am trying to create  a graph that plots the following over time:

 - internal profit projections vs analyst consensus over time (this is straight forward to do with the y axis being £m and the x axis being date.
Now I wish to plot the Company share price over the same time period, but I don't know how to overlay this data with a separate scale in pence  - using the other y axis to the right of the graph

Question by:Robyn123
    LVL 6

    Expert Comment

    Add a secondary vertical axis (Excel 2007):
    LVL 45

    Accepted Solution


    I note from your profile that you are a new Premium Service Member to Experts Exchange - welcome.

    Perhaps you are not aware of how the points system works for the answerers. It works as follows. Let's assume it's for a question for which 500 points have been offered by the Questioner:  
    Points offered    Grade         Multiplier      Answerer receives    Cost to Questionner  
    500                       A                4                 2000                             500  
    500                       B                3                 1500                             500  
    500                       C                2                 1000                             500  
    It is also important  to point out that as a Premium Service Member you can ask as many questions as you like and offer up to 500 points for a question. As you can see it does not cost you more to award an A. However if you feel that your question has not been answered fully or for example you have only been given a partial answer then a B grade is fair. However it is only right that you say in what way your question has not been fully answered and before you 'Accept' an answer with the intention of awarding a B grade you ensure you have specified in detail what you are needing and that you have given answerers ample opportunity to provide an answer that solves your problem.
    Please do not leave questions open for ever. If you abandon a question, after 21 days it will be considered as abandoned and will be dealt with by the clean-up volunteers. If a good answer has been given then the points and grade will be awarded to the answerer. So you cannot 'save' points by not 'Accepting' an answer.  Apart from which as a Premium Service Member 'saving' points does not affect the cost of your subscription.
    On the matter of obtaining good answers, it is very much up to the questionner to respond to comments and to supply further information or feed-back. These are crucial elements to the whole EE process. You will find that the better your feedback the better the answers will be. The answerers are all unpaid volunteers, many but not all of whom work in the IT industry. So they are here because they want to be, not because it earns them a living - because it doesn't!
    I do hope that helps and that you will accept these comments as just helpful - as that's how they are intended.

    LVL 45

    Expert Comment


    Please upload your file.


    Author Closing Comment

    The only problem I had was that I needed to upgrade to Excel 2007 from Excel 2003 in order to achieve this

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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

    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    This is about my first experience with programming Arduino.
    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 …

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now