How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36777
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have been asked to develop a line graph, showing months on

Customer Question

I have been asked to develop a line graph, showing months on bottom, types & catergory. This is to show a trend. How do I organize the data in the excel and create the line graph to show a trend.

I will send you excel file as this is needed for 2 Regions and want this line graph to make sense.

Criteria:

1. 12 Months: Jan-December

2. Catergories : 1. Helpdesk & 2. Corrective Action

3. Types:1. Technical Equip 2. Bldg. Repair 3. Catering 4. Janitorial 5. Soft Services

Use a line graph to illustrate the Trend by months for the types & categories.

Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Richard replied 4 years ago.
Hi there and welcome
Can you please upload the file to www.wikisend.com
Provide me the download link and I can than look at this for you.
Thank you
Customer: replied 4 years ago.

http://wikisend.com/download/129070/Work Order - Oct 2012 Type line graph.xlsx

Work Order - Oct 2012 Type line graph.xlsx

Expert:  Richard replied 4 years ago.
Thanks Sue, looking at it now
Expert:  Richard replied 4 years ago.
Done Sue
You can download it from here
http://tinyurl.com/ahqvg4l
If you have any questions at all, please do not hesitate to let me know.
Thank You
Richard
Customer: replied 4 years ago.

Hello:

Is there anyway to combine categories (Helpdesk & Corrective Maintenance) on one line graph showing the trend for the types by month?

Expert:  Richard replied 4 years ago.
it can Sue,
I have done it for you and it can be downloaded here
http://tinyurl.com/ca68zdq
Feel free to ask if you need more information
Customer: replied 4 years ago.

I can not open in excel .

Expert:  Richard replied 4 years ago.
What happens when you try to open it Sue?

Related Microsoft Office Questions