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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.