First, I want to say I love this board. Its amazing how many of my questions have already been answered.
I am using Excel 2000 and have been asked to create an aging chart. I'd like to say that Charts are not my strong suit (although when I'm done with my current project I'll be an expert <g>)
I have a column chart of the number of new trouble tickets incoming for each week.
I have # of units on the Y axis and dates (as text) on the X axis to represent the week ending.
Now I've been asked to "turn the chart on its right side and create an aging chart with 30, 60, 90 days along the bottom"
So now I am going to chart the number of days the trouble ticket is open.
Not only can I not get the 30, 60 ,90 along the bottom but I'm having a hard time figuring out what to chart along the other axis. The person requesting this chart is unavailable. I keep picking bar chart but suspect there is a better choice.
I have searched the web looking for examples of charts and something showing the number of days along the bottom. I keep feeling there's some slick combination that will give me what I want.
Anyone out there have some ideas of the best way of showing this data and then how to do the chart?
Thank you.
Kathy Zawacki
I am using Excel 2000 and have been asked to create an aging chart. I'd like to say that Charts are not my strong suit (although when I'm done with my current project I'll be an expert <g>)
I have a column chart of the number of new trouble tickets incoming for each week.
I have # of units on the Y axis and dates (as text) on the X axis to represent the week ending.
Now I've been asked to "turn the chart on its right side and create an aging chart with 30, 60, 90 days along the bottom"
So now I am going to chart the number of days the trouble ticket is open.
Not only can I not get the 30, 60 ,90 along the bottom but I'm having a hard time figuring out what to chart along the other axis. The person requesting this chart is unavailable. I keep picking bar chart but suspect there is a better choice.
I have searched the web looking for examples of charts and something showing the number of days along the bottom. I keep feeling there's some slick combination that will give me what I want.
Anyone out there have some ideas of the best way of showing this data and then how to do the chart?
Thank you.
Kathy Zawacki