darrellj

Scatter Plot With Dates

Recommended Posts

Hello.

I have an issue I was hoping to get some help with. I have a scatter plot graph that has dates on the x-axis and numbers on the y-axis. The dates on the x-axis are about 52 apart. I need to display the x axis based on the date. For example:

 

1/1/2011 - 1/31/2011 - all values for the x-axis need to be from x point 0 to 51.

2/1/2011 - 2/29/2011 - all values for the x-axis need to be from x point 52 to 103.

3/1/2011 - 3/31/2011 - all values for the x-axis need to be from x point 104 to 155.

 

What I'm doing is setting the y-axis to the number of sales for that day (which works) but I need to adjust the x-axis to be accurate. The trouble that I seem to be having is getting all of the sales from January in between January and February and so on.

 

Attached is what the chart looks like now.

 

Any advice?

 

Thank you so much in advance for any help!

post-22030-0-05835700-1317312726_thumb.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now