Graph help

experts,

Not sure how I can graph the attached.
I need to show it per month for both shaded groups in the attached excel.

not sure if this is a dual axis or not.  

thank you for the help
EE-Graph.xlsx
pdvsaProject financeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Tony PittConnect With a Mentor Commented:
Ah - I misunderstood which columns were to be included.  (I had explicitly removed those :-()

Anyway, try this instead.

/T
EE-Graph.xlsx
0
 
Jeff DarlingDeveloper AnalystCommented:
not sure if this is what you are looking for or not.

The Month needs to be converted rather than just "formatted"

sample attached
EE20150224-EEGraph.xlsx
0
 
gowflowCommented:
Does this help ?
gowflow
EE-Graph.xlsx
0
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.

 
Tony PittCommented:
If I understand the requirement correctly, here's what you're after.

What you've got to do is to make the "Month" column into a real date.  Excel is interpreting it as a date and making 14-Oct into 14/10/2015 (UK date style - dd/mm/yyyy!) when I suspect you mean it to be 1/10/2014.

I've inserted a column that transforms the dates so that Excel understands them, inserted a simple line graph and then used a custom number format to render the dates on the horizontal axis in the same format as you had them.  I hope this is correct ... and helpful!

/T
EE-Graph.xlsx
0
 
pdvsaProject financeAuthor Commented:
Tony that is close.  How do I add the other data set?   columns E & F?
0
 
pdvsaProject financeAuthor Commented:
Tony, I mean D and F
0
 
pdvsaProject financeAuthor Commented:
geez...sorry I think I mean D and E.  The shaded ones are being compared as a group.   I need C with D and E with F.
0
 
pdvsaProject financeAuthor Commented:
very nice.  I think I see that my issue was the formatting of the date.  I did format it but I guess that was not  a "real" format.  

anyhow, thank you very much.
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.

All Courses

From novice to tech pro — start learning today.