[Webinar] Streamline your web hosting managementRegister Today

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

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
0
pdvsa
Asked:
pdvsa
1 Solution
 
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
 
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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
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
 
Tony PittCommented:
Ah - I misunderstood which columns were to be included.  (I had explicitly removed those :-()

Anyway, try this instead.

/T
EE-Graph.xlsx
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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