How to compare 2 sets of data in one graph?

[haganator]

I'm trying to compare 2 weeks worth of data on 1 graph, and I'm having difficulty trying to get the x-axis to label correctly for the second week. I can't seem to rotate it or move it or anything. Week 1 dates can be altered, but not week 2. I can manually add the week 2 date to the week 1 cell by using Alt-Enter to add lines and then I can rotate the dates to line up with their corresponding data, but I'm trying to get away from the manual changes. Here is a snapshot:


-- removed inline image ---

Any suggestions would be greatly appreciated.

Thanks in advance,
Jeff

 

[mgm05267]

OOPS... I think something is missing...

 

[haganator]

OOPS... I think something is missing...

You're right...hold please.

 

[haganator]

OOPS... I think something is missing...

MGM,

I"m not able to use MrExcel HTML Maker or Excel Jeanie. They are .xla files and my excel (2007) says they are not valid. I can't seem to get the pic to post.

Jeff