How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jason Jones Your Own Question

Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 14683
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason Jones is online now

I need to create a graph that has two y axes (one for units

Resolved Question:

I need to create a graph that has two y axes (one for units and one for revenue £000k), with three different categories. I want the units as a stacked bar chart and the revenue shown as lines, unless you think two stacked bar charts works/looks better.

The date is as follows:
FY13/14 FY14/15 FY15/16 FY16/17 FY17/18
Recurring Revenue Contracts 10 26 46 73 124
Capital Sales 2 9 20 39 67
Maintenance 0 9 20 39 67
FY13/14 FY14/15 FY15/16 FY16/17 FY17/18
Recurring Revenue Contracts 145.3 461.5 1175.7 2355.7 4287.4
Capital Sales 157.9 712.5 1583.3 3087.5 5304.2
Maintenance 0.0 18.8 78.5 208.3 419.4

Can you please help I am going mad! I am using 2010.

Paul
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Jason Jones replied 2 years ago.

Hello and thank you for your question today. My name is Jason. I look forward to helping you today.

May I ask that you describe the chart a bit more?

In your example data, you have what seems to be, three values "Recurring Revenue Contracts", "Capital Sales", & Maintenance. Which of these three values are the two that you want charted? Also, what is FY13/14 and the rest of the items that look like that?

Thank you,
Jason
Customer: replied 2 years ago.

Hi Jason


Thanks for coming back to me.


 


FY13/14 etc refers to the financial years that will form the x axis.


 


Essentially there are two blocks of data that I wish to plot (1. number of units by recurring revenue contracts / capital sales / maintenance, and 2. revenue by recurring revenue contracts / capital sales / maintenance).


 


I would like the the y axis on the left hand side of the graph to reflect the units, and this data to be presented in a stacked bar chart. Whilst the y axis on the right hand side to reflect the revenue (£000), with three lines (recurring revenue contracts, capital sales and maintenance).


 


I have attached what I have achieved so far!


 


Hopefully this makes sense.


 


Paul

Attachment: 2014-03-25_114227_germany_-_sales_graph.xlsx


 

Expert:  Jason Jones replied 2 years ago.


Thank you for the update.

You have three values in the first set and three values in the second set. Do you want each value in each set to have it's own bar? (ie: 3 bars for the first set and 3 bars for the 2nd?) Or do you want to sum them up first?

Customer: replied 2 years ago.

Each value must be kept separate - so for the stacked bar chart (to show units) there should be three different coloured stacks, which tie into the y axis on the left.


Then for the revenue there should be a separate line for each set of values (i.e. recurring revenue contracts, capital sales & maintenance), which ties into the y axis on the right.


 

Expert:  Jason Jones replied 2 years ago.

Thank you for the update Paul.

I now understand.

You can add each series one at a time.

Please, follow the instructions on the following page that I found for you: http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx#BMsecondaryverticalaxis

There is a bit of leg work that you must complete. If you have any issues with that process, please, let me know.

Thank you again for your time.

I look forward to your next message or your rating below.

To rate me, you can click one of the faces below and click Submit/Ok or click the Accept button.

If you ever wish to work with me in the future, you can ask your new questions and have them sent to me directly at the following page: http://www.justanswer.com/computer/expert-computertechmaster/

Thank you again,
- Jason

Customer: replied 2 years ago.

Jason


 


This is ridiculous. This is one of the set of instructions I tried to follow which wouldn't work - which is why I contacted you.


 


A complete waste of my time and money. Are we able to speak so that you can guide me through the instructions?


 


When I click on the chart I do not get, go to the format tab I do not have the opportunity to get a secondary axis.


 


I still need help - can we speak rather than do this by email?

Expert:  Jason Jones replied 2 years ago.


I am sorry to hear that Paul.

I will walk you through it.

May I remote into your system and show you how to do this?

Customer: replied 2 years ago.

That sounds like a good idea. Thanks.

Expert:  Jason Jones replied 2 years ago.


Thank you.

Please, click the following link and choose to run the remote application: http://166.78.231.170:8040/?Session=a88fda12-9fb2-4576-a6e1-a4809e71b1b2

Customer: replied 2 years ago.

We are connected

Expert:  Jason Jones replied 2 years ago.
Thank you
Expert:  Jason Jones replied 2 years ago.

All is now working.

If you ever wish to work with me in the future, you can ask your new questions and have them sent to me directly at the following page: http://www.justanswer.com/computer/expert-computertechmaster/

Thank you for your time and please, do not forget to rate my help below.

- Jason
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 14683
Experience: Over 10 years work experience.
Jason Jones and other Microsoft Office Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Previous | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    233
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    119
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    56
    Bachelor's Degree in Information Technology, Microsoft Certified Professional