Help me.... first time having to do something in Excel
So here's the deal:
I worked solving help desk tickets, and now for some reason my boss wants me to make a chart that shows the amount of tickets created and resolved per week kinda like this: https://www.google.com/search?q=excel+charts&aq=f&um=1&ie=UTF-8&hl=en&tb...
He wants the vertical line to indicate the qty of tickets both solved and created in the same bar, and he wants the horizontal line to be divided by week of the year...
We currently have a table that contains the list of tickets with a created date and a resolved date...
Can someone plz help me for I have no idea how to even begin :(
to add your file to the post,
to add your file to the post, log in, click on "Edit" and add the file
Can you give your worksheet
Can you give your worksheet (dropbox e.g.) in public, so that I can see what the data looks like. As I read your topic I suggest you should create a chart with 2 vertical axes, e.g. leftside the amount tickets created and rightside the resolved ones.