troubleshooting Question

Line Chart in Excel 2007

Avatar of Blair Benjamin
Blair BenjaminFlag for United States of America asked on
Microsoft Excel
10 Comments2 Solutions335 ViewsLast Modified:
Hello.  I'm trying to make a line chart using Excel data, but I can't seem to figure out how to get the results I want.  I'm thinking that it can't be this complicated.  I have a spreadsheet with dates of sales - one column has dates for Jan-May of 2011 and another has dates for Jan-May of 2012.   I want two lines on the chart representing the two years, with the y-axis having the # of sales and the x-axis having date ranges (say, every X days or so).  My data might look like this, with a date representing each sale (so there would be multiple entries with the same date).
Column 1
1/1/2011
1/2/2011
1/2/2011
1/2/2011
1/4/2011
1/6/2011
1/6/2011

Column 2
1/1/2012
1/1/2012
1/2/2012
1/3/2012
1/3/2012
1/4/2012
1/8/2012
1/8/2012
1/8/2012

How might this be accomplished?  Thanks to anyone who can help!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros