Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

Dual Axis

Experts,

How would I be able to present this data in a graph per year and quarter?  I think it is dual axis.

ie:  Board Operators 1 compared to Board Operators 2 over each year and quarter.
EE---Dual-Axis.xlsx
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Katie PierceCommented:
In the chart ribbon, select "Change Chart Type", then select the series and you can select "Secondary Axis" for it.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

can you mock up a chart with the drawing tools and explain what the desired outcome is?  If you want columns on different axes, then you will need to change the data layout considerably. Before we go into that, I'd like to know what you really want to show.

cheers, teylyn
0
 
gowflowCommented:
Is this what you want I just madeup 2 types of graph line and Bar

gowflow
EE---Dual-Axis.xlsx
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Ouch, my eyes are hurting. 3D column charts --- noooooooo!

Gowflow, with all due respect, but how does that answer the question? That's just a plain data dump into a chart.

For a comparison between two data sets, you would need to chart one group of data on a different axis. Using a column chart, this would require a staggered data layout.

This would be a bit of work on the original data.

Hence my question to pdvsa for clarification and a mock-up of the desired result.

Why don't we wait for the response before charging into blind click-and-chart activities?

cheers, teylyn
0
 
gowflowCommented:
well for me it was a simple question but if your read it to be complex then yes it can be a possibility, so then lets wait to see OP's answer.
gowflow
0
 
gowflowCommented:
I don't know, here is an other attempt adding total per year. I hope not going to be showered again !!!
gowflow
EE---Dual-Axis-V01.xlsx
0
 
pdvsaProject financeAuthor Commented:
Thank you.  Sorry for my tardy reply.  I will respond soon.   My "real" job has been taking my time lately.
0
 
pdvsaProject financeAuthor Commented:
Experts, thank you.  I appreciate the comments.   I split them between all.  My dataset has been changing and is now in a different format. Once I know more I will possibly ask another question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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