• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Microsoft Excel Graph 3 series of data

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



0
Robyn123
Asked:
Robyn123
  • 2
1 Solution
 
bluepigCommented:
Add a secondary vertical axis (Excel 2007):
http://office.microsoft.com/en-us/excel/HP012341651033.aspx
0
 
patrickabCommented:
Robyn123,

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.

Patrick
0
 
patrickabCommented:
Robyn123,

Please upload your file.

Patrick
0
 
Robyn123Author Commented:
The only problem I had was that I needed to upgrade to Excel 2007 from Excel 2003 in order to achieve this
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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