Excel 2007 : Need Help Excel Graph

[Jovillanueva]

Hi Forumer's

I'm newbie inthis forum.

Just wat to share with you.
My objective is to make a graph based on the changes of return type turn around time and month to date.
and also the occurence of return type month to date.

I have this data the original return type and received date and new return type and correction date plus the TAT.
can i ask your help on how to make grap on this. thanks.

insert sample data.

regards and thank you.
JOV

[dilipandey]

Hi JOV,

See the attached file where I have shown Old return type, new return type and TAT via line charts against Sales IDs.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Jovillanueva]

Thank you very much DILIPandey!


I have another Query.
Attaching my sample data2.
Based on this data i would like to create a graph display the occurences of OriginalReturns changes to NewReturns based on Correction Months. what graph should be look like.? or what the data should be look like?

Thanks and regards,
JOV

[dilipandey]

You are welcome JOV,

I have gone through the attached sample file and not been able to understand your query.

Do you want to display Cosmetic enteries against Match & NTF enteries over displayed months? Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>