grouping date on x axis

[josephinetedesc]

Hi I have about 1000 data points, of dates and widgets sold.  I want to make a graph with date on the axis, however i want it to show as a very long trend graph.  I want to show from 2001 Jan to Dec then 2002 , jan to Dec then 2003 Jan to Dec.  I am having a lot of trouble.

I have tried adding the dimension Year(saledate)&'/'Month(saledate) and sort by saledate - but still get very odd graph.

Jo

[sushil353]

Hi,

Try adding dimension using monthname function

MonthName(saledate) as monthyear

HTH

Sushil

[rwunderlich]

Try setting on "Continuous" in the Axes tab.

-Rob

http://masterssummit.com

http://robwunderlich.com

[josephinetedesc]

Sushil Kumar this is what I get:  still cannot sort  i don't know if you can see it but the 1st and last valure are Nov 2002 and Dec 2002 - the rest seems ok!

[josephinetedesc · Accepted solution]

Actually I think it is correct ... I just redid the chart

1. changed the chart (chose it from Right click  the sheet )

2. expanded and saw that the correct sequence ...

Thank you