Charts Pivots Excel

Hi,

I am new to Pivot charts and graphs in Excel. Can some one help me in creating charts. I need to know the steps you took
to come up with the chart. Instructions,  Data and final output chart are attached in the attachment s provided.
I will be highly Obliged as I really need to understand it. Thanks  a lot!
SampleData.xlsx
Instuctions.docx
Tulip_23Asked:
Who is Participating?
 
RobOwner (Aidellio)Commented:
What have you tried so far?  

Select all the data, go to the data tab and click pivot table / chart.  Doesn't get much easier
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Why don't you have a read of these four articles, starting from http://www.filecats.co.uk/how-can-filecats-save-me-time-and-money/count-different-types/

It shows all the steps to produce Pivot Tables and charts. PivotCharts are covered in the third and fourth articles, but it's important to know the beginning steps as well.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
With regard to your specific question, the attachments indicate that the assigment is homework.

Here are the rules on EE regarding homework:


the Experts want to help you learn to accomplish the task or solve the problem when you face it in real life, so they will help guide you to the correct solution, but they are not permitted to provide the solution for you.


Here are some examples of questions that fall outside the scope of Experts Exchange:

Asking to have a program, application, or complex query written for you. This also includes work that would typically require you to hire an independent contractor.
Copy & pasting your assignment or homework questions without including the work you've already done. Experts are prohibited from providing complete answers to exam questions, homework assignments, or projects as this violates the academic honesty clause in section 16 of the Code of Conduct.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Tulip_23Author Commented:
Hi Phillip,

Thanks for taking time to read my question and replying back. Also Thanks for informing me about the code of conduct. How ever this is not  home work assignment but I am trying to get it done for my work as I am back filling for some one on vacation, I suggested to y manager I could do it as I know excel but now I am stuck,didn't know it will be so complex.
I tried looking at videos on line but ended in confusion. You can take a look at what I have done and provide suggestions if you have time. Thanks a lot in advance.
myOutput.xlsx
0
 
Tulip_23Author Commented:
PFA my work, can some one help me come up with correct graph.
final graph is provided in the Attachment Instructions.
I cant seem to understand how to have percentage met, day5 and percentage day10 on same graph.
0
 
Tulip_23Author Commented:
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.