I just want to show order date and ship date values in a single bar or line chart.Is there any way to do this ?
Attached sample workbook here.Thanks in advance.
You have to transpose (Pivot) your date fields which will make easy for your to achieve the output.
Just select both dates and pivot.
Now go to sheet and drag pivoted fields like that
Hope this help.
Retrieving data ...