Excel Help - two sets of data for the x-axis in a line graph 2

[cjbrown815]

Excel 2010 - I have a simple line graph and I need to display/sort the x-axis first by date (all of the G column) and then by Quality Code (all of the E column). Basically two products come in per day and I need to seperate those. So I will have two data points per day.

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

try...
[tt]
=E2 & "-" &text(H2,"yyyy/mm/dd")
[/tt]
and copy down thru all rows of data

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

To wrap this up (because I hate unfinished threads) I used this formula

=TEXT($H$2,"mm/dd/yyyy") & "-" & $E$2

where H column has the date and E column has the Quality Code and then add it to the horizontal axis of my graph and it works awesome. Thank you Skip and Fred for working this out with me!!

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931